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.

N77MDDerby Michael R · Falls Church, VABuilt 1970 · S/N E-234N77MS5foot Face Flight Inc Trustee · Wilmington, DEBuilt 1983 · S/N E-2116N77NWRizor Justin · Phoenix, AZS/N TK-141N77PGJjo Aero LLC · Keller, TXBuilt 1991 · S/N E-2680N77QJBelzberg Gary Md · Sneads Ferry, NCBuilt 1967 · S/N D-8610N77QQBurkhardt Wayne W · Deming, NMBuilt 1979 · S/N D10251N77RJWilkinson Dane W · Morgan, UTBuilt 1960 · S/N D-6533N77RRWilson Jonathan G · Granbury, TXBuilt 1964 · S/N TC-823N77RTBouchier Thomas B · Post, TXBuilt 1978 · S/N TJ-135N77SMHuberty Gregory N · Billings, MTBuilt 1975 · S/N TE-1023N77VBMorgenroth Aviation LLC · Victoria, TXBuilt 1974 · S/N D-9629N77VKPontiac Flying LLC · Pontiac, ILBuilt 1970 · S/N E-221N77XFDuwane D Skipper · Booker, TXBuilt 1977 · S/N D-9989N77XSCarlson Jonathan J · Hernando, MSS/N D-3446N77YEHaagenson Trevor O Trustee · Carnelian Bay, CABuilt 1975 · S/N TE-1074N77YTN77yt LLC · New Canaan, CTBuilt 1979 · S/N EA-10N7800YH&H Aviation Of Oklahoma LLC · Oklahoma City, OKBuilt 1978 · S/N D-10072N7801YRed Baron Aviation LLC · Denver, COBuilt 1978 · S/N TC-2139N7802RPiroli John M · Nokomis, FLBuilt 1968 · S/N D-8886N7803RRick Franklin Corp · Lebanon, ORBuilt 1968 · S/N TE-637N7807RRife Rick R · Scottsdale, AZBuilt 1968 · S/N D-8889N7810CTryton Aviation LLC · Reston, VABuilt 1955 · S/N G-767N7813RGonzales Donald W DBA · Mercer Island, WABuilt 1969 · S/N D-8912N7817LNyerges James · Midland, TXFirst renewal noticeBuilt 1967 · S/N LD-340N7817RTrew Glen · Nashville, TNBuilt 1968 · S/N TE-666N781AAN781aa LLC · Junction City, KSBuilt 1961 · S/N TC-38N781JBKilgus Christopher R · Felton, CABuilt 1968 · S/N MB-405N781LDKeane James P · West Islip, NYBuilt 1978 · S/N D-10132N781WCOak And Pine Ranch LLC · Kalispell, MTBuilt 1987 · S/N CE-1156N781YToole William Barry · Goochland, VABuilt 1977 · S/N MC-544N781ZFolk Jerald F · Ocklawaha, FLBuilt 1960 · S/N D-6471N782Dillon T34 782 LLC · Scottsdale, AZBuilt 1954 · S/N CG58EN7820RGabriel Donald E · Tucson, AZBuilt 1968 · S/N D-8866N7821RRegistered aircraftBuilt 1968 · S/N TC-1196N7823RJeffco LLC · Wasco, CAS/N TC-1197N7828RHoward Donald V · Goldthwaite, TXFirst renewal noticeBuilt 1968 · S/N D-8903N7829CNogle Charles H · Champaign, ILBuilt 1949 · S/N G-95N782AN782a Leasing LLC · Linden, MIBuilt 1961 · S/N TD-469N782KAaron Daryl G · Rosenberg, TXBuilt 1965 · S/N TC-924N782YBeitler Richard J · Pittsburgh, PABuilt 1978 · S/N M-2004N7832RSmith Brian S · Johnson City, TNBuilt 1969 · S/N D-8916N7835VRoney John P · Charlotte, NCBuilt 1978 · S/N D-10155N7837REob Aviation LLC · Grand Haven, MIBuilt 1969 · S/N TE-675N7839RMuddy Wolf Holdings LLC · Wilmington, DEBuilt 1969 · S/N TE-672N783JR13 Aviation LLC · Chelan, WABuilt 1979 · S/N TJ-231N783PTJones Kenneth C · Newark, DEBuilt 1965 · S/N TC-808N783TMElliott Frank A · Oxford, MSBuilt 1973 · S/N D-9489N7841MDocmax LLC · Tucson, AZBuilt 1964 · S/N D-7398N7841RMadariaga Gregory M · San Diego, CABuilt 1969 · S/N TC-1202N7843LLampe Robert T · Kendall, KSS/N D-8817
Back to AD 99-05-13 R1 WD