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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N925QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1961 · S/N D-6821 N925RCCastle Shelter Group LLC · Clearwater, MNBuilt 1969 · S/N D-9001 N925SLInnovative Aviation LLC · Deatsville, ALBuilt 1976 · S/N E-938 N925TPreserve Land Company LLC · Franklin Lakes, NJBuilt 1964 · S/N D-7371 N925TPKtm Projects LLC · Durant, OKBuilt 1976 · S/N TJ-35 N925VVEndicott Properties LLC · Hilton Head Island, SCS/N TJ188 N9260QToomey Neal P · Huntington Beach, CABuilt 1971 · S/N CE-348 N9260SChristiansen Dee W · Kerrville, TXBuilt 1975 · S/N MB-781 N9262QPrince John Curtis III · Frierson, LABuilt 1971 · S/N CE-320 N9264FWilson Jonathan · Natchez, MSS/N M-476 N9266QDecastro Susan · Westborough, MABuilt 1972 · S/N TE-861 N9268QWeyhmuller Luke · Chapin, SCBuilt 1971 · S/N E-279 N926BTTelematic Systems Inc · North Fort Myers, FLBuilt 1977 · S/N TE-1110 N9270SVinson Raymond R III · Mckinney, TXBuilt 1975 · S/N MC-392 N9271SLife Is A Beech LLC · Commerce City, COBuilt 1976 · S/N M-1757 N9273QFrost Scott · West Palm Beach, FLBuilt 1971 · S/N E-280 N9273SYonly Abner Wanah · California, MDS/N M-1759 N92756Dakota Express LLC · Wilmington, DEBuilt 1965 · S/N BA-728 N9275SCole Larry G · Pigeon Forge, TNBuilt 1976 · S/N M-1763 N9276QSunrise Aeronautics LLC · Punta Gorda, FLBuilt 1971 · S/N CE-342 N9276SMoody Daniel F · Lafayette, LABuilt 1976 · S/N M-1764 N9278SSpeed Kenneth W · Redington Shores, FLBuilt 1976 · S/N M-1765 N927AWLambert Contracting LLC · Hollywood, ALBuilt 2001 · S/N E3426 N927BWRiverbend Aviation LLC · Hernando, MSBuilt 1979 · S/N TC-2292 N927DCCiruli David E · Lafayette, CABuilt 1976 · S/N D-9855 N927JBAirgroup Express LLC · Santa Rosa, CABuilt 1980 · S/N D-10345 N927MWStrauss Michael · Ormond Beach, FLBuilt 1973 · S/N D-9546 N927PRMichael Magic Carpet LLC · Stuart, FLBuilt 1962 · S/N TC-335 N927WCalabrese Joseph Jr · Winamac, INBuilt 1979 · S/N M-2258 N9281SBmc2 LLC · Phoenix, AZBuilt 1976 · S/N M-1790 N9282QMsxpert LLC · Sheridan, WYBuilt 1971 · S/N TE-842 N9282SMorgan John S · Athens, ALBuilt 1974 · S/N M-1624 N9283SRegistration Pending · Johnson City, TNRegistration pendingBuilt 1975 · S/N M-1625 N9284STamad Aviation LLC · Tracy, CABuilt 1975 · S/N MC-329 N9286QDunn Louis · Hampshire, ILBuilt 1971 · S/N E-291 N9287QElarel Corporation · Lewes, DEBuilt 1971 · S/N D-9287 N9287SDale Michael W · Clayton, NCS/N MB-758 N9288QKarle John F · Long Beach, CABuilt 1971 · S/N E-288 N9289QCoutu Bobby L · Plano, TXBuilt 1971 · S/N D-9289 N9289SThomsen Patrick J · Star Prairie, WIBuilt 1975 · S/N M-1651 N928ARGuluzza Gary W · Canyon Country, CABuilt 1979 · S/N M-2236 N928EFAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1979 · S/N ME-136 N928KMSchmoker William C · Eden Prairie, MNBuilt 2001 · S/N EA-672 N928MMRegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N D-8942 N928RJGibson Aviation LLC · Draper, UTBuilt 1976 · S/N MC385 N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138 N9290HDelta Enterprise · Brighton, COBuilt 1944 · S/N 6726 N9290SRoss Executive Aviation Inc · Fort Smith, ARBuilt 1975 · S/N M-1627 N9293QChalk 2 Inc · Apple Valley, CABuilt 1971 · S/N D-9293 N9295SSteadman John Harold · Santa Clarita, CABuilt 1975 · S/N M-1630

Back to AD 99-05-13 R1 WD