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.

N1265ZGertsen Ronald H · Glenwood, NJBuilt 1961 · S/N TC-111N1267ZN1267z LLC · Indianapolis, INBuilt 1961 · S/N D-6707N1268ZTodd Cori L · Gladewater, TXBuilt 1961 · S/N TC-84N1269ZChilds Lowell R · Elgin, ILBuilt 1961 · S/N TC-85N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257N126GLN126gl LLC · Roca, NEBuilt 1975 · S/N E-763N126HBockman Ltd · Milford, IABuilt 1967 · S/N D-8544N126SAS2 Aviation LLC · Biloxi, MSBuilt 1959 · S/N D5817N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126N126WGN126wg LLC · Oak Brook, ILBuilt 1972 · S/N D-9315N12711Oxman Judith R · Riva, MDBuilt 1965 · S/N D-5834N1271ZV-Four Ltd · Hudson, OHBuilt 1961 · S/N D-6723N1273SSullivan Stephen G · Mize, MSBuilt 1969 · S/N D-8937N127FCalifornia In Nice Inc · San Jose, CABuilt 1965 · S/N TC-869N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212N127RWWindmiller David · Melville, NYBuilt 1976 · S/N TC-1958N127TBTorongo William Martin · Grayling, MIBuilt 1956 · S/N D-4590N1282ZBrickhouse Aviation LLC · Franklin, TNBuilt 1961 · S/N D-6711N1284ZDubose Alexander R · Durham, CABuilt 1961 · S/N TD-458N1285ZRivera Luis Jr · Spring, TXBuilt 1961 · S/N TC-100N128AEChiave Solutions LLC · Orlando, FLBuilt 1981 · S/N E-1830N128KJm Lavore Aero Inc · Lakeside, MTBuilt 1961 · S/N TD-488N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220N128WMOac Aviation LLC · Asheville, NCBuilt 1997 · S/N E3115N128XHaynes Bruce A · Welches, ORBuilt 1951 · S/N D-2818N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030N1298ZShaw Aviation LLC · Greenleaf, IDBuilt 1961 · S/N D-6738N1299ZWojdac David E · Mosinee, WIS/N TD-467N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561N129BTinney William G · Macon, GAFirst renewal noticeS/N D-4433N129BMMain Gary Michael · Haverford, PABuilt 2004 · S/N E-3588N129EEBuntings Grassroots Aviation LLC · Selbyville, DEBuilt 1977 · S/N CE-693N129QFlying J Aviation Pllc · League City, TXS/N TC-847N129RJKenney Donill · Lake Worth, FLBuilt 1980 · S/N E-1752N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835N129TRDawson Aircraft Inc · Clinton, ARBuilt 1994 · S/N E-2888N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586N12AVChambers Richard A · Sandpoint, IDFirst renewal noticeBuilt 1975 · S/N CE-603N12BTexacali Air LLC · Salado, TXBuilt 2001 · S/N E-3392N12BDChaos Aviation LLC · Warrenton, VAS/N G-116N12BGFull Scale Aviation LLC · Mccordsville, INBuilt 1982 · S/N TC-2412N12BRManning Richard F · Midway, GABuilt 1957 · S/N D-5391N12BUVan Liew Bradford · Johns Island, SCBuilt 1968 · S/N TE-595N12DKTim Cross Aviation LLC · Tucson, AZBuilt 1967 · S/N TE-290N12EUInternational Air Services Inc Trustee · Carson City, NVS/N P582N12FGEchols Mill Aviation LLC · Elberton, GABuilt 1998 · S/N E-3219N12FHR&B Leasing And Finance LLC · Fresno, CABuilt 1956 · S/N DH-63N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789N12HMRigsby Robert A · Burien, WABuilt 1956 · S/N D-4740N12KCHeath David A Trustee · Cottonwood, AZBuilt 1965 · S/N D-7867
Back to AD 99-05-13 R1 WD