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.

N1821DBowman Kent · Rexburg, IDS/N D-3090N1821WModern & Classic Aviation LLC · North Royalton, OHBuilt 1973 · S/N TC-1522N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377N1822SSnider Nancy J · Washington, DCBuilt 1981 · S/N TC-2357N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424N1822XRegistered aircraftBuilt 1981 · S/N M-2327N1823WMuhler Wayne · Brighton, COS/N TC-1509N1823YSpenner Herbert C · San Jose, CABuilt 1981 · S/N WA-290N18242Huuki Matt · Atlantic Mine, MIBuilt 1981 · S/N WA-294N18245N18245 Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1977 · S/N P-429N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N1824PHoffman Warren S · East Meadow, NYBuilt 1981 · S/N MC-759N1824XKepo Aviation LLC · Ball, LABuilt 1981 · S/N MC-760N18251Rushing Daniel W III · Inlet Beach, FLS/N M-2329N18253Glass Anthony A Trustee · Plano, TXBuilt 1977 · S/N E-1067N18255Registration Pending · Los Olivos, CARegistration pendingS/N G-739N18258Haas Edward L · Conroe, TXBuilt 1982 · S/N WA-299N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877N1825SEngebretson Christopher D · Greenville, INS/N E-1898N18265Strance Gordon M · Sevierville, TNBuilt 1987 · S/N E-2381N1826DDeoiveira Vitor · Shrewsbury, MABuilt 1983 · S/N WA301N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086N1826WOzark Mountain Airways LLC · Springfield, MOBuilt 1973 · S/N TC-1510N18271Ramsey Richard K · Houston, TXBuilt 1977 · S/N E-1068N18273Hussey Mathias C · Frisco, TXBuilt 1977 · S/N TC-2065N18275Strong Tower Worship Center LLC · Delhi, LAS/N E-1071N18276Stack Ed · Prospect Heights, ILS/N D-10031N1827ZGray Amber · Forestville, CABuilt 1981 · S/N MC-762N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N18284Condor Aviation LLC · Bethlehem, PABuilt 1977 · S/N E-1073N18287Three Wings Aviation LLC · Kalispell, MTBuilt 1977 · S/N D-10032N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837N1828LTye Boys LLC · Tulia, TXBuilt 1976 · S/N P-385N18290Koelbel Scott W · Spring, TXBuilt 1977 · S/N E-1076N18291Meoli Christopher J · Rancho Mirage, CABuilt 1977 · S/N CE-724N18294Bundy Holdings LLC · Walnut Grove, MOBuilt 1977 · S/N D-10034N1829WRight Wing LLC · Newnan, GABuilt 1973 · S/N E-387N182QWhitt Carson M · Deland, FLBuilt 1964 · S/N D-7646N182TPepper Gregory Lee · Fayetteville, GABuilt 1967 · S/N TD-687N18302Allison Aircraft Sales LLC · Avon, CTBuilt 1977 · S/N E-1081N18304Bean David Jay · Miami, TXBuilt 1977 · S/N D-10037N18307Wings Management LLC · Springville, UTBuilt 1977 · S/N D-10038N18308Jlmc Blackland LLC · Marietta, GABuilt 1977 · S/N E-1083N1830BLeading Edge Leasing LLC · Wilmington, DEBuilt 1981 · S/N TC-2410N1830FKing Barry J · Bentonville, ARBuilt 1981 · S/N E-1905N1830MDcf30 Corp · Doral, FLS/N E575N1830SN1830s Aviation LLC · Gainesville, GABuilt 1981 · S/N E-1906N1830VStress Aircraft Holdings LLC · Pilot Mountain, NCBuilt 1997 · S/N E-3087
Back to AD 99-05-13 R1 WD