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.

N774DFEclipse Aviation LLC · Las Vegas, NVBuilt 1964 · S/N D-7395N774SDr Leasing Ltd · Wilmington, DEBuilt 1966 · S/N D-8088N7755KSkyview Aviation LLC · Benton, KYS/N TC2067N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394N775JWCunningham William R · Broken Arrow, OKBuilt 1968 · S/N CJ-2N775TSorensen Craig A · Fallon, NVBuilt 1974 · S/N D-9664N775VCAmaria Marzban Keki · Riverside, CABuilt 1992 · S/N CE-1704N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283N7761RMarrow Henry Gregory · Southern Pines, NCBuilt 1968 · S/N D-8879N7762RPossumtown Alleycats LLC · Midland, TXBuilt 1968 · S/N TE-650N7765RDumbo Aviation LLC · Omaha, NEBuilt 1968 · S/N D-8882N7768RIvey Martin J · Dennis, TXBuilt 1968 · S/N D-8897N7769RPelican Air Inc · Kersey, PABuilt 1968 · S/N D-8906N776BGas Corporation Of America · Wichita Falls, TXS/N D-1786N776DBHagglund Carl D · Pendleton, ORBuilt 1952 · S/N D-3046N776DRDel Rossi Anthony J · Key Largo, FLBuilt 1976 · S/N P390N776PAMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME-284N776PSPyle Dana C · Naples, FLBuilt 1974 · S/N TC-1815N776RFTrzcinski Douglas R · Chesapeake, VABuilt 1949 · S/N D-2082N776YDRapp Larry · Elbow Lake, MNBuilt 1988 · S/N E-2463N7770XT Bone Air LLC · Missoula, MTBuilt 1960 · S/N HH-139N7772RBpk Ventures LLC · Jupiter, FLBuilt 1968 · S/N D-8896N7773RHeikes Derek M · Denton, TXBuilt 1968 · S/N TC-1181N7774RTruman Operations Limited Partnership · Imperial, NEBuilt 1969 · S/N TC-1228N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191N7777RBryson Thomas M · Jackson, MSBuilt 1962 · S/N D-7050N777AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-899N777BLexair Corporate Aviation · Miami, FLBuilt 1948 · S/N D-1787N777BAGado Theodore A · Cortlandt Manor, NYBuilt 1972 · S/N D-9408N777BCBas Part Sales LLC · Greeley, COBuilt 1966 · S/N D-8230N777BVPowell Robert W · Horseshoe Bay, TXBuilt 1971 · S/N TE-829N777CEMiller Dana · Tracy, CABuilt 1977 · S/N D-10019N777CZFunchess Thomas A · Hazlehurst, MSBuilt 1970 · S/N TE-809N777DKLeeth Bryan Conway · Carrollton, GABuilt 1967 · S/N TE-443N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347N777EVSelldorff John · Chatham, MABuilt 1990 · S/N E-2520N777FHShort Final LLC · Mooresville, NCBuilt 1964 · S/N D-7530N777GPAkc Aviation LLC · Lake In The Hills, ILBuilt 1962 · S/N D-7009N777GWC & D Morgan LLC · Dalton, NEBuilt 1979 · S/N P-501N777HGProcyon Group Inc · Wilmington, DEBuilt 1975 · S/N E-777N777JMFulton David S · Austin, TXBuilt 1966 · S/N D-8085N777KFJ And P Air LLC · Lockport, NYBuilt 1963 · S/N TC-520N777KWBenner Dick L · Clancy, MTBuilt 1968 · S/N D-8892N777LLHelfrich Vincent · Lawrence, MABuilt 1971 · S/N TC-1410N777MMJsgjr LLC · Fife, WABuilt 1997 · S/N EA-597N777MYGraham Elmer R Jr · Graford, TXBuilt 2000 · S/N E-3328N777NKTaylor Jonathan K II · Granbury, TXBuilt 1996 · S/N E-2996N777NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N CE861N777PBWw Build Inc · Deland, FLBuilt 1973 · S/N E-439N777PDIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N D-10380
Back to AD 99-05-13 R1 WD