OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N5570ZShippers Lee D · Wolcott, NYBuilt 1962 · S/N 22-9364N5571ZGlass John · San Luis Obispo, CABuilt 1962 · S/N 22-9366N5572HKnutson Wayne R · Tioga, NDS/N 11-964N5572ZGilmer Rickey W · Cropwell, ALBuilt 1962 · S/N 22-9369N5573HSauter Allen · Bismarck, NDBuilt 1949 · S/N 11-1094N5573ZHerrick David · Mont Vernon, NHBuilt 1962 · S/N 22-9373N5574HAjmi Amal R · Fairbanks, AKBuilt 1949 · S/N 11-1099N5575HCizek Joseph E · Wasilla, AKBuilt 1949 · S/N 11-1100N5575ZLareaux Jon R · Calumet, MIS/N 22-9375N5577ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1962 · S/N 22-9378N5578HJohnson Tim L · Stanley, NDBuilt 1949 · S/N 11-1105N557CGGoss Carmon G · Mc Clure, PABuilt 1947 · S/N 12-2215N5580ZMorrow G Warren · Center, MOS/N 22-9382N5582CAlaska Department Of Public Safety · Anchorage, AKS/N 18-8473N5582ZStottlemyer Bradley J · Lake Geneva, WIBuilt 1962 · S/N 22-9387N5583ZWoods Robert L · Kenly, NCBuilt 1962 · S/N 22-9390N5584H51 Pacer LLC · Jacksonville, ORS/N 20-644N5584ZDerrico Andrew D · Leesburg, FLS/N 22-9393N5585ZHeitz John W · Manvel, TXBuilt 1962 · S/N 22-9394N5586HCannata Michael A · Estancia, NMBuilt 1951 · S/N 20-647N5586ZKoenig Anthony Scott · Huntsville, TXBuilt 1962 · S/N 22-9395N55871Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6409N5587ZWeesies Jack · Saint Petersburg, FLBuilt 1962 · S/N 22-9396N5588ZSpooner John A · Hickory, NCBuilt 1962 · S/N 22-9397N5589HAdams Trevor J · Burlington, WABuilt 1951 · S/N 20-651N5589JFrank Investments Inc · Austin, TXBuilt 1954 · S/N 18-3332N5589ZDayton Stephen G · Littleton, NHBuilt 1962 · S/N 22-9399N5590HZonnefeld Mark J · Olathe, KSBuilt 1951 · S/N 20-653N5590ZWhitaker Shawn P · Mount Pleasant, SCBuilt 1962 · S/N 22-9400N5593HLandreth Homer W · Peoria, AZBuilt 1951 · S/N 20-655N5593ZEastern Stearman Inc Trustee · Leesburg, VABuilt 1962 · S/N 22-9404N5595HHornby James C · Kaukauna, WIBuilt 1951 · S/N 20-659N5596ZLamb Steve E · Big Bear City, CABuilt 1962 · S/N 22-9407N5597HNicholson Robert Lyle · North Ogden, UTS/N 20-661N5598ZEkstrom David L · Bemidji, MNBuilt 1962 · S/N 22-9409N55DVDevine William L Jr · Maple Falls, WABuilt 1948 · S/N 14-192N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55UBEuroaviation Inc Trustee · KematenBuilt 1956 · S/N 18-4264N5600HGreen James H · Bladenboro, NCS/N 16-207N5601HPierce Stephan L · Graham, TXBuilt 1949 · S/N 16-208N5603ZAngerman Ronald A · Gilbert, SCBuilt 1962 · S/N 22-9413N5605ZMossman Aaron P · West Plains, MOS/N 22-9408N5607ZCorcoran Francis A · Rochelle, ILBuilt 1962 · S/N 22-9418N5608ZSale Reported · Casper, WYSale reportedBuilt 1962 · S/N 22-9420N5609ZRowland Gary W · Edmond, OKBuilt 1962 · S/N 22-9421N5610HReese Christopher R · Hanover, MNBuilt 1949 · S/N 16-217N5610ZMcvey James W · Mentor, OHBuilt 1962 · S/N 22-9422N5613ZAndersen Zachary J · Seward, AKBuilt 1962 · S/N 22-9424N5615ZKuebler Terry T · Gahanna, OHBuilt 1962 · S/N 22-9427
Back to AD 99-01-05 R1