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.

N299CLNealy Steven · Eaton, COBuilt 1986 · S/N CE-1092N299JNSpell Harry · Oregon, ILBuilt 1971 · S/N M-1315N299KAir Transport LLC · Troy, MTBuilt 1979 · S/N TJ-185N299WAccelerated Information Technologies Inc · Gates Mills, OHBuilt 2001 · S/N E-3382N29APItzkowitz Arnold · Selbyville, DEBuilt 1993 · S/N E-2823N29BAMax Q Aviation LLC · Kalispell, MTS/N BA-625N29CCSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-117N29DCDwlg Aviation LLC · Rogers, ARBuilt 1965 · S/N D-7943N29DLCrouch David T · Asheville, NCBuilt 1976 · S/N E-913N29EALorimor Thomas T · Sidney, IABuilt 1976 · S/N CE622N29HPRusso Kevin J · North Branch, NJBuilt 1976 · S/N E-831N29JRLulafay LLC · Lewes, DES/N MA-235N29RFCaldwell Rob · Danville, KYBuilt 1979 · S/N E-1445N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N29TCBeach Bonanza LLC · Shreveport, LABuilt 1991 · S/N E-2644N29VRegistered aircraftBuilt 1972 · S/N D-9340N29WC29wc Inc · Malta, NYS/N E-1642N29YPeters Duane A · Anchorage, AKS/N EH-16N2ASSupkis Daniel E Jr · Houston, TXBuilt 1979 · S/N P-511N2BBLowry Air LLC · Tahlequah, OKBuilt 1972 · S/N TC-1447N2CBBoxman LLC · Wilmington, DEBuilt 1977 · S/N D-10090N2CSBolton Geoffrey M · Groveland, CABuilt 1973 · S/N D-9463N2DCGottsleben John J · Tucson, AZBuilt 1964 · S/N D-7318N2DNHaines Matthew E · Lake Dallas, TXBuilt 1973 · S/N D-9426N2DQLemont Corp · Southwest, PABuilt 1967 · S/N TG-3N2DRGustafson Dale H · Kingwood, TXBuilt 1962 · S/N D-6924N2DURegistered aircraftBuilt 1977 · S/N D-10030N2EYBender Jeffrey T · Scottsdale, AZBuilt 1967 · S/N D-8401N2FKAshwath Nagaraj · Los Altos Hills, CABuilt 1978 · S/N CE-834N2GRRichardson Gordon B II · Caldwell, TXBuilt 1961 · S/N D-6659N2HJLittle Eagle Valley LLC · Dover, DES/N CE-542N2JCJcmc Inc · Junction City, KSBuilt 1984 · S/N E-2172N2JEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N P-358N2JXBrookeash Inc · Waxahachie, TXBuilt 1965 · S/N D-7811N2KBKb Aviation LLC · Mission Viejo, CABuilt 1974 · S/N E-599N2KMBas Part Sales LLC · Greeley, COBuilt 1973 · S/N TC-1608N2LHStotlar Richard L · Tucson, AZBuilt 1987 · S/N CE-1133N2MLMclaury Kim · Mission Hill, SDBuilt 1997 · S/N E-3114N2TDRds LLC · Strongsville, OHBuilt 1949 · S/N D-2004N2UGBaker Gregory L · Hilton Head Island, SCBuilt 1988 · S/N CE-1267N2UTDemaeyer Thomas A · Fort Lauderdale, FLBuilt 1969 · S/N TC-1203N2VDFloyds Aero Inc · Amarillo, TXS/N G-784N2VRRead Andrew R · Milwaukee, WIBuilt 1980 · S/N EA-62N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37N2VYSmith William E Jr · Havre De Grace, MDBuilt 1955 · S/N BG-67N2ZTwo Zulu LLC · Mclean, VABuilt 1989 · S/N E-2514N2ZWThordarson Gudsteinn Thor · La Porte, INBuilt 1956 · S/N D-4564N3001CHoyt Robert H · Canby, ORBuilt 1958 · S/N D-5664N3002CAviation By Gosh LLC · Burlington, TXBuilt 1958 · S/N D-5665
Back to AD 99-05-13 R1 WD