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.

N264QChan Hung-Chun · Orem, UTBuilt 1966 · S/N TC-987N264SBCkw Aviation LLC · Dalhart, TXS/N TE-1125N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316N265DDebalco Enterprises Inc DBA · Colorado Springs, COBuilt 1980 · S/N P-548N265EStaggerwing 265e LLC · Wilmington, DEBuilt 1943 · S/N 4940N265RVWb Aviation LLC · Saint Jo, TXS/N E3512N2663Nc2663 Inc · Wilmington, DEBuilt 1939 · S/N 330N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205N266JDJ D Deboskey Inc · Palm Beach Gardens, FLS/N G-810N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654N266TCAir Control Systems · Bigfork, MTS/N EA-483N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672N267PDWhite Hat Repair LLC · Greenleaf, IDBuilt 1967 · S/N TE-284N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045N26865Coastline Bonanza LLC · Bedford, NHBuilt 1986 · S/N E-2319N268AFApogee Flight Inc · Bellingham, WABuilt 1961 · S/N G-828N268EAAir Ally Asset Management LLC · Chisago City, MNS/N E-3476N268RKalhart Transportation Services Inc · Rancho Santa Fe, CABuilt 1977 · S/N E1092N268RCGraor Robert A · Las Cruces, NMBuilt 1977 · S/N P-416N268SAInarayan Inc · Winter Park, FLBuilt 1963 · S/N TC-554N2690AHamons Jeffery W · Perrysburg, OHBuilt 1978 · S/N E-1264N2693KKelman Naomi · Nashville, TNBuilt 1980 · S/N CE-820N269BACorporate Aviation Center LLC · Wilmington, DEBuilt 1958 · S/N D-5618N269EAAviar Io LLC · Parker, TXS/N E-3472N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N26BRStender Aviation B LLC · Huntsville, ALBuilt 1983 · S/N E-2072N26CSJetswiss LLC · Overland Park, KSBuilt 1993 · S/N E-2814N26DEContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N TC-1796N26EPErid Air LLC · Blackfoot, IDS/N D-5533N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N26JJCrescenzo David G · Hammonton, NJBuilt 1975 · S/N TE-1058N26KGarrett Robert A · Dallas, GABuilt 1954 · S/N G-57N26LMClassic Aviation Inc · Pella, IABuilt 1979 · S/N ME-177N26PLTwin Beech LLC · Kalispell, MTBuilt 1964 · S/N BA-679N26PVWoods H Ross · El Dorado, ARBuilt 1971 · S/N CE-347N26QRSolesbee Nathan Arthur · Anaheim, CABuilt 1979 · S/N EA-19N26RGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1987 · S/N E-2383N26RTInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N CE-1292N26TDTamaco2 LLC · Jackson, MOBuilt 1969 · S/N M-1228N26TMBennett Christopher J · Marrero, LABuilt 1978 · S/N MC-638N26URDartswift Inc · Philadelphia, PABuilt 1988 · S/N CE-1274N270Young Aviation LLC · Panama City, FLBuilt 1961 · S/N DH-308N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7
Back to AD 99-05-13 R1 WD