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.

N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496N144RCKilgore Shawn K · Argyle, TXBuilt 1974 · S/N TC-1750N144SBPeters Aircraft Sales Flp · Wshngtn Ct Hs, OHBuilt 1979 · S/N CE-862N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289N1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCBuilt 1977 · S/N E-989N1450LByrd Aviation LLC · Marshfield, MOBuilt 1965 · S/N M-845N1451GCox Keith L · Griffin, GABuilt 1962 · S/N TC-249N1454GN1454g LLC · Knoxville, TNBuilt 1962 · S/N D-6914N1455GNell James E · Pagosa Springs, COBuilt 1962 · S/N D-6920N1459GBeeson Chris · Graford, TXBuilt 1962 · S/N D-6917N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235N145DDemaray Russell N · Sedona, AZBuilt 1980 · S/N TC-2348N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061N145SBBaksa Stephen · Chatham, NJBuilt 1956 · S/N G-148N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507N1462LSchneider Matthew B · Laughlin Afb, TXS/N M-857N1463LSpears Martin J · Havelock, NCBuilt 1965 · S/N M-858N1465LLoehr Fred A III · Rio Rancho, NMBuilt 1965 · S/N M-862N14661Badenhope John R · Greeneville, TNS/N D-2978N1466LSteel Randy W · Madras, ORS/N M-880N1468LCh Repairs LLC · Statesboro, GAS/N M-864N146BPNoughton Larry W · Fort Myers, FLBuilt 1994 · S/N CE-1775N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N146DSale Reported · San Diego, CASale reportedBuilt 1948 · S/N D-1791N146RAerospatiale LLC · Selah, WAS/N HH-145N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N1470LAl-Rubaiie Haider A · Fort Worth, TXBuilt 1965 · S/N M-866N1471LLee Michael Jason · Berryville, VABuilt 1965 · S/N M-867N1475L2328 Charlie Victor LLC · Richmond, KYBuilt 1965 · S/N M-871N1477GDobson John F · Union, WABuilt 1962 · S/N D-6980N1477LCooper Jonathan Thomas · Tempe, AZBuilt 1965 · S/N M-874N1478LBaline Lonny R · Harleysville, PABuilt 1965 · S/N M-873N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163N147GGZeng Robert E · Owasso, OKBuilt 1962 · S/N TC-260N147PN147p LLC · Wilkesboro, NCBuilt 1979 · S/N CE-868N147PWBarr Tammy D · Spicewood, TXBuilt 2001 · S/N E-3420N147UMartin Delano R · Spring, TXS/N D-8533N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102N1480KTheberge Jane A · Oakland Park, FLBuilt 1961 · S/N BA-601N1481LOsceola Aviation Services Inc · Lake City, FLBuilt 1965 · S/N M-879N1485GHarris John F III · Louisburg, NCBuilt 1962 · S/N D-6933N1487LSheets Mark W · Chugiak, AKBuilt 1965 · S/N M-887N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437N1492LSalzer Mychael D · Coulterville, ILS/N M-892N1497GDiaz Jose R · Bakersfield, CABuilt 1962 · S/N D-6936
Back to AD 99-05-13 R1 WD