OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N1414LBrown Joseph T · Saginaw, MIBuilt 1965 · S/N M-806N1416GNixon Terry L · Enid, OKBuilt 1961 · S/N D-6896N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550N1417GRomney James J · Fruit Heights, UTFirst renewal noticeBuilt 1962 · S/N D-6902N1417LBright David P · Wachapreague, VABuilt 1965 · S/N M-809N1419GMcneal James B · Beaufort, SCBuilt 1962 · S/N D-6900N141CLFulbright Charles M · Toccoa, GABuilt 1967 · S/N TD-692N141GWaller Steven M · Sterling, COBuilt 1954 · S/N D-3975N141HPBrankin Enterprises Inc · Dover, DES/N E-1815N141PNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-237N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995N141ZAVintage Flying Machines Inc · Huntington, INS/N BA-178N1420GRamsey April Dawn · Saraland, ALBuilt 1962 · S/N TC-238N1421GGomez Vecslir Martin L · Redwood City, CABuilt 1962 · S/N DH-333N1422LTonka Seaplanes LLC · Minnetonka, MNBuilt 1961 · S/N D-6584N1423LMedi Carriers Of Wisconsin Inc · Greenville, WIBuilt 1965 · S/N M-817N1426LMartin Michael D · Decatur, TXBuilt 1965 · S/N M-820N1427GCarter Geoffrey R · Ormond Beach, FLBuilt 1962 · S/N D-6903N142FGall Peter · Morgantown, WVBuilt 1966 · S/N TE-221N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020N142MPeterson Dana Timothy · Eldersburg, MDBuilt 1960 · S/N D-6585N142MCCassen Mark E · Wilson, WYBuilt 1973 · S/N TC-1579N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71N1431LJke Family Fun Entertainment Inc · Searcy, ARBuilt 1965 · S/N M-827N1432LStrydom Cornelis F · Liberal, KSBuilt 1965 · S/N M-826N1434LPost Greg G · Mapleton, KSBuilt 1965 · S/N M-829N1436LDelis Costa Z · Heyburn, IDS/N M-831N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013N1437GMason Mark D · Brighton, COBuilt 1962 · S/N D-6910N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664N143PDSouder James B · Port Orange, FLBuilt 1953 · S/N 53-4134N14409Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1934 · S/N 21N1440R39a LLC · Sioux Falls, SDBuilt 1966 · S/N TE-175N14413Central Air Service Inc · Lewistown, MTBuilt 1935 · S/N 38N14417Haring Clay A · Lincoln, KSBuilt 1935 · S/N 30N1441LSayre Jeremy Q · Livonia, MOBuilt 1965 · S/N M-835N1444GLam Lawrence Y · Rosemead, CAS/N D-15002N1444LClifton Gary R · Fowler, INBuilt 1965 · S/N M-838N1448GMotions Dynamics LLC · Campbellsville, KYBuilt 1962 · S/N D-6916N1449GFayettenam Aero LLC · Laurinburg, NCS/N TC-248N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633N144FFoster Gary E · Kress, TXBuilt 1963 · S/N D-7142N144GMWilliams David · Golden, MOBuilt 1962 · S/N D-7010N144KPrescott Medical Relief Services LLC · Prescott, AZBuilt 1977 · S/N E-947N144LHPaul John R · Hamilton, MTS/N RLH14N144LMHobert Robert W Trustee · Penn Valley, CABuilt 1957 · S/N D-5267N144NBWiley C Sanders Jr · Troy, ALBuilt 1955 · S/N BA-39
Back to AD 99-05-13 R1 WD