OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,519

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.

N120RDDecesare George D · Danville, CABuilt 1956 · S/N DH-89N120SPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N P-538N120WMLift Enterprises LLC · Lynn Haven, FLBuilt 1955 · S/N D-4260N120WTZulu Time LLC · Park City, UTBuilt 1980 · S/N EA-99N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418N1215TShepphird John C · Reno, NVBuilt 1966 · S/N TE-102N1218Nogle Charles H · Champaign, ILFirst renewal noticeBuilt 1956 · S/N BG-163N1218ZHutsell James M · Miamisburg, OHBuilt 1961 · S/N D-6682N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126N121BCCavanaugh Collections Inc · Addison, TXS/N G-123N121BEKrdm LLC · Fallon, NVS/N D-7920N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256N121DSongbird Aviation LLC · Larkspur, CABuilt 1984 · S/N CE-1033N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359N1220Technical Education Services Inc T/A · Virginia Beach, VABuilt 1947 · S/N D-927N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276N1223TBeech Club LLC · Meadville, PABuilt 1980 · S/N M-2272N1223Z2dwh LLC · Katy, TXBuilt 1961 · S/N TC-67N12250Renforth Michael · Yorktown, VABuilt 1955 · S/N G-701N12252Maresco International Corp · Alpha, NJBuilt 1965 · S/N G-704N12253Breitenstine Matthew · Dallas, TXS/N G-705N12255Cirrus Management LLC · Suwanee, GAS/N G-707N12258Bacon Otis Blake · Fremont, CABuilt 1955 · S/N G-722N1225ZFree Gregory · Monroe, IABuilt 1961 · S/N D-6692N12264Enk William A Sr Trustee · Blue Springs, MOBuilt 1956 · S/N G-818N12275Bachman Mildred R · New Brighton, PABuilt 1965 · S/N G-263N12281Flippen John P · Bonita, CABuilt 1955 · S/N G-293N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577N1228ZPate Ronald E · Hilltop Lakes, TXBuilt 1961 · S/N D-6688N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070N122GSDixie Aviation Enterprises LLC · Gallatin, TNBuilt 1979 · S/N BA-259N122GTSperr Adam C · Donnelly, MNBuilt 1980 · S/N E-1673N122LDennis Harley E Sr · Cole Camp, MOBuilt 1956 · S/N D-4579N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413N122PGMcgaw Thomas D · Petaluma, CABuilt 1961 · S/N TC-149N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177N122RRDebold David A · Spring, TXBuilt 1961 · S/N D-6706N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794N122VWJk Aviation LLC · Fresno, CAS/N D-6435N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875N1231ZD&J Vtail LLC · Punta Gorda, FLBuilt 1961 · S/N D-6693
Back to AD 99-05-13 R1 WD