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.

N851KProtac Aviation LLC · Jackson, WYBuilt 1986 · S/N CJ-178N851TDuke Boys LLC · North Sioux City, SDBuilt 1968 · S/N TG-68N8521MStarr Aero LLC · Tempe, AZBuilt 1963 · S/N D-7213N8525AAuten Charles W III · Parker, COBuilt 1949 · S/N D-2023N8528MSheldon Randy C · Osceola, MOS/N D-7192N8529MSpivey Yancy D · Nocona, TXBuilt 1963 · S/N D-7193N852RRauch Karl W · Fredericksburg, VABuilt 1959 · S/N D-6183N852TStudarus John E · Sacramento, CABuilt 1974 · S/N M-1528N853Cameo Marketing Inc · Ellsworth, MES/N D-9888N8531AChappie Michael R · Sidney, OHS/N D-1953N8533MDrill Driver LLC · Livingston, TXS/N D-7199N8534MSimons Torrence · Keene, TXBuilt 1963 · S/N D-7200N8536MReever John J · Dover, PABuilt 1963 · S/N D-7198N8537MRegistered aircraftBuilt 1963 · S/N TD-534N8538AWeeks Stanley III · Taneyville, MOS/N D-1960N8538MSt Clair Arthur · Monroe, NCBuilt 1963 · S/N D-7211N853KTKansas State University Salina · Salina, KSBuilt 1993 · S/N CE-1765N853RBelknap Aero Services LLC · Meredith, NHBuilt 1959 · S/N D-6193N853THumphrey Daniel P · Sausalito, CABuilt 1974 · S/N D-9630N8540MMcdaniel David S · Madill, OKBuilt 1963 · S/N TC-510N8541MPorter Matthew R · Stephenville, TXBuilt 1963 · S/N D-7201N8542MCross Colin · Alameda, CABuilt 1963 · S/N D-7202N8544MKc Storm Survey Services LLC · Liberty, MOBuilt 1963 · S/N D-7203N854PRegistered aircraftBuilt 1980 · S/N CE-886N8550MHuber Pamela J · Lake City, FLBuilt 1963 · S/N D-7209N8552RBlanco Diego A · Miami, FLBuilt 1974 · S/N CE-533N8557RC & G Enterprises LLC · Chesterfield, VABuilt 1974 · S/N TC-1768N8558AAerobanc Of America Inc · Camarillo, CABuilt 1949 · S/N D-1980N8558MA & C Customs LLC · Caddo Mills, TXBuilt 1963 · S/N D-7216N855CZimmerman Walker D · Nashville, TNS/N TC-796N855DVon Dresky Inc · Fort Collins, COBuilt 1967 · S/N TE-466N855DCCunningham Mark · Paris, TXS/N E-3585N855DSAerolutions LLC · Preston, IDBuilt 1966 · S/N D-8287N855MCAmerican Flight Museum · Topeka, KSS/N BG-189N8562RTj Airholdings Inc Owner Trustee · Wilmington, DEBuilt 1974 · S/N CE-534N8565AHendricks Allan T · Pearland, TXBuilt 1949 · S/N D-1987N8565MMundt Paul W · Henderson, NVBuilt 1963 · S/N D-7208N8566RSouthwest Fresh Potato LLC · Hugoton, KSBuilt 1974 · S/N D-9684N8568MMoore Charles B · Miles City, MTBuilt 1963 · S/N D-7215N856B4261bravo Corp · Wilmington, DEBuilt 1961 · S/N D-6778N8570MChester Steven G · Aurora, COBuilt 1963 · S/N D-7129N8571AWilliams Alan P · Bossier City, LABuilt 1949 · S/N D-1993N8572MSignor Jeff R · Alta Loma, CAS/N D-7217N8577ANissen Chris · Sandy, ORBuilt 1948 · S/N D-1999N8577MSkyfix International Inc · Fort Lauderdale, FLBuilt 1963 · S/N TC-479N8577QRegistration Pending · Amarillo, TXRegistration pendingS/N D-8208N8577RPhillips Law Firm LLC · Marietta, GABuilt 1974 · S/N E-596N8578ABonanza Parts Inc · Davis, CABuilt 1949 · S/N D-2000N857BCCynamon Bruce · Weirsdale, FLBuilt 1968 · S/N D-8885N857CTpcj Group LLC · Arlington, TXBuilt 1975 · S/N CE-560
Back to AD 99-05-13 R1 WD