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.

N9220SWard Jessica · Southport, NCBuilt 1975 · S/N MC-380N9221QPhelan Raymond F · Portland, ORBuilt 1971 · S/N D-9264N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718N9223QElling Fred · Tucson, AZBuilt 1971 · S/N CE-350N9225QTh Real Estate Solutions LLC · Bossier City, LABuilt 1971 · S/N CE-343N9226QBelanger Bobby Lee · New Braunfels, TXBuilt 1971 · S/N E-284N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723N9229SRegistered aircraftBuilt 1975 · S/N M-1724N922BVander Linden Tom · Fairfield, IABuilt 1966 · S/N TC-994N922CWAngel Flyers LLC · Charlottesville, VABuilt 1994 · S/N E-2886N922DRAdams Paul · Lake Havasu City, AZBuilt 1989 · S/N CE-1361N922LZTmde Calibration Labs Inc · Richmond, MEBuilt 1974 · S/N TE993N922PJHaynes Jonathan T · Billings, MTBuilt 1955 · S/N 34-57N922QDragonlady Barron LLC · Gardnerville, NVBuilt 1961 · S/N TC-202N922RPink Ibis Air LLC · Vero Beach, FLS/N TE-273N922RBCunningham John P · Anthony, NMBuilt 1974 · S/N TC-1694N922VCorbin Tommy · Channelview, TXS/N TC-1742N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N9233QMid America Aviation LLC · Wilmington, DEBuilt 1971 · S/N D-9274N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727N9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N M-1728N9238SAllt International LLC · Parker, COBuilt 1976 · S/N M-1760N9239SRoyer Richard W · Winnebago, MNBuilt 1975 · S/N M-1732N923AKHenderson Alexander · Zephyr Cove, NVBuilt 1971 · S/N E-285N923RLUrquhart Kris · Fallon, NVBuilt 2004 · S/N E3537N923VDog House Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N M-1591N923WDDubose W P III · Columbia, SCBuilt 1974 · S/N TC-1786N9241SCosby Asa · Weldon, CAS/N M-1734N9242QSample Donald L · Houston, TXBuilt 1970 · S/N D-9242N9243QFlegler Barry Bronson · Eagle, MIBuilt 1970 · S/N D-9243N9244SKonefal Arthur Joseph · Fairbanks, AKBuilt 1975 · S/N M-1740N9245SMowery Joseph · Orlando, FLBuilt 1975 · S/N M-1741N9248QLedbetter Finley L · Graford, TXBuilt 1971 · S/N TC-1397N924CTGo South LLC · Ruleville, MSBuilt 1979 · S/N CE-889N924JRegistered aircraftS/N BA-163N924KGHairston Hollie Brenton · Bryan, TXBuilt 1979 · S/N E1507N924RBHitendra Chaturvedi · Chandler, AZBuilt 1979 · S/N E-1612N924RHSmith Joelene K · Avon, INBuilt 1978 · S/N E-1288N924VBauman Ronald L · Stuttgart, ARBuilt 1974 · S/N D-9702N924Y924y LLC · Visalia, CABuilt 1998 · S/N E-3198N9251SAayan Air LLC · Westfield, MABuilt 1975 · S/N MC-387N9253QN9253q LLC · Goldsby, OKBuilt 1971 · S/N D-9253N9253SKnuth Charles Allen · Avon, INBuilt 1975 · S/N M-1750N9254SHolmes Jeffrey T · Oxford, CTBuilt 1975 · S/N M-1751N9257QC9 Aero LLC · Gothenburg, NEBuilt 1971 · S/N E-277N9259SAlles Harry · Greeley, COBuilt 1975 · S/N MC-389N925CPoms Scott H · San Mateo, CABuilt 1977 · S/N E-1057N925DJErvin Joshua C · New Plymouth, OHBuilt 1958 · S/N DH-195N925MVan Wylen Mary F · Grand Rapids, MIBuilt 1973 · S/N D-9474N925PGSumthin Limited · Wilmington, DEBuilt 1979 · S/N TC-2288
Back to AD 99-05-13 R1 WD