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.

N6032MHbb Inc · Birmingham, ALBuilt 1979 · S/N CE-848N6032SRenk Brett J · Sun Prairie, WIBuilt 1975 · S/N P-332N6032UDeepark Karan Trustee · Spring, TXBuilt 1979 · S/N E-1471N6032VLawler Craig R · Milton, PABuilt 1979 · S/N D-10227N6032XWinged Chariot LLC · Cincinnati, OHBuilt 1979 · S/N TJ-197N6033FSky View Aviation LLC · Benton, KYBuilt 1965 · S/N TD-626N6033XBennett Jerry W Jr · Spring Branch, TXBuilt 1979 · S/N TC-2220N60343Crow William David · Katy, TXS/N TC-2222N6034EKoch Gary B · Roseville, CAFirst renewal noticeS/N D-5953N6034RKelsoe Robert L · Dallas, TXFirst renewal noticeBuilt 1979 · S/N E-1474N6034XHill Farms D&K LLC · Condon, ORBuilt 1979 · S/N E-1477N60357Central Flying Service LLC · Little Rock, ARBuilt 1979 · S/N E-1478N6035BMontgomery Aviation Corporation · Montgomery, ALFirst renewal noticeBuilt 1980 · S/N D-10348N6036GBulldawg Aviation LLC · Helena, MTBuilt 1979 · S/N D-10229N6037EN6037e LLC · Williamstown, WVBuilt 1959 · S/N D-5998N6037GMojo Travel LLC · Wellington, COBuilt 1979 · S/N TK-96N6037WMidland Community College District · Midland, TXBuilt 1979 · S/N TC-2238N6038QMiller Larry L · Orlando, FLBuilt 1979 · S/N CE-852N60394Sears Brothers Farming · Joes, COBuilt 1979 · S/N D-10233N6039ELangford John · Pilot Point, TXS/N D-5991N6039RRegistered aircraftBuilt 1979 · S/N E-1489N6039TLindsey Kenneth H · Kalispell, MTBuilt 1979 · S/N TK-97N6039ZZandi Aziz · Greeley, COS/N E-1490N603JHAirdent LLC · Trinity, FLBuilt 1978 · S/N E-1271N60402Bajaj Rajesh · Florence, SCBuilt 1979 · S/N E-1498N60405Aero Quest LLC · Olive Branch, MSBuilt 1979 · S/N ME-173N6040FJct Holdings LLC · Henderson, NVS/N D-7814N6041EGirod Consulting Inc · Duncan, OKBuilt 1959 · S/N D-5975N6041FKabo LLC · Las Vegas, NVBuilt 1965 · S/N D-7816N6041UCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N ME-175N6041XRegistration Pending · Solvang, CARegistration pending, pending cancellationBuilt 1979 · S/N MC-656N6041ZEmpower Electric LLC · Waukesha, WIBuilt 1979 · S/N M-2163N6042FFly Aviation Corp · Wilmington, DEBuilt 1979 · S/N ME-176N6042ULion Facility Engineering Consultants LLC · Inyokern, CABuilt 1979 · S/N MC-659N60433Texas Triple Net Gp LLC · Austin, TXBuilt 1979 · S/N MC-661N6043EWhitaker Charles D · Kettering, OHBuilt 1959 · S/N D-5983N6043JCore Paul F · Frisco, TXS/N M-2168N6043YFreeman Eugene P · Paducah, KYBuilt 1979 · S/N WA-16N6044DBuckingham Brian L · Fletcher, NCBuilt 1979 · S/N MC-662N6044ESuperstar Aog LLC · Tallahassee, FLBuilt 1979 · S/N MC-664N6044SPinewood Properties LLC · Hayward, WIBuilt 1976 · S/N TJ-42N60451Jkg LLC · Murfreesboro, TNBuilt 1979 · S/N ME-193N6046EMaltby Gary M · Malvern, ARBuilt 1959 · S/N D-5976N6046WFamily & Friends Flying LLC · Livonia, MIS/N M-2172N6047ECampisi Brian James · Eliot, MEBuilt 1959 · S/N D-5971N6047JKimplex Co LLC · Port Charlotte, FLBuilt 1979 · S/N M-2174N6047SNeihouser Brad · Francesville, INBuilt 1976 · S/N TJ-37N6047ULarson John Howard · Kerrville, TXBuilt 1979 · S/N MC-667N6048C4g Aerobatics LLC · Saint Petersburg, FLBuilt 1975 · S/N P-348N6048ESones Kelly L · South Lake Tahoe, CABuilt 1959 · S/N D-5973
Back to AD 99-05-13 R1 WD