Registered aircraft · 47,142

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

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') ORDER BY n_number

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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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.

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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1256Towner Jason A · Burneyville, OKBuilt 2004 · S/N 1205 N1256SBrant P Rouse Dds Plc · Tahlequah, OKBuilt 1976 · S/N 18264825 N1257RWells Carolyn B · Whitefish, MTBuilt 1966 · S/N 4325 N1257SKidd Bryce · Clovis, NMBuilt 1976 · S/N 18264826 N12580White River Ag Spraying Llp · Newport, ARBuilt 1964 · S/N 18051458 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N1258RUnderland Evageline D · Willmar, MNS/N 4329 N1258SN76bt LLC · Lynnfield, MAS/N 33701894 N1258VSutton Aircraft Salvage LLC · Palmer, AKS/N R1722154 N1259ML A M Capital Management LLC · Sheridan, WYBuilt 1967 · S/N CE-175 N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZBuilt 1980 · S/N EA-169 N125BEGomez Eliud · Winter Park, FLS/N TH-43 N125BMBaron Transporation Services LLC · Destrehan, LAFirst renewal noticeBuilt 1978 · S/N 21062926 N125BRRh22 LLC · Tampa, FLBuilt 2004 · S/N 1221 N125BTPointe Companies Inc · Silver City, NMBuilt 2009 · S/N 411125 N125CAFabre And Co LLC · Baton Rouge, LABuilt 2024 · S/N 9922 N125CPLinscott Jeffrey R · Boring, ORBuilt 1972 · S/N 340-0093 N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176 N125ETGrindeland Ethan P · Hatton, NDBuilt 1958 · S/N 35706 N125FDJ Gonzales Properties LLC · Prairieville, LABuilt 2023 · S/N 9082 N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025 N125KTRustair Inc · Anchorage, AKBuilt 1977 · S/N 18503494 N125LCStrike Fund LLC · Peachtree City, GAS/N 0100 N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417 N125MWMishler Kenneth C · Lawrence, KSBuilt 1973 · S/N 18262211 N125PBEvergreen Financial Investments LLC · Wayzata, MNBuilt 1977 · S/N 18265348 N125PCRegistered aircraftBuilt 1978 · S/N D-10148 N125RLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2335 N125SFCovino John M · Ashland, MABuilt 2005 · S/N 1593 N125TR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1973 · S/N D-9560 N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3 N125WAHorton Kelly · Hollis, OKBuilt 1975 · S/N 18263594 N1260RLife Builders International · Albert Lea, MNBuilt 1967 · S/N 4332 N1260ZFaris Isaac · Swartz Creek, MIBuilt 1961 · S/N D-6704 N1261RHuff Joshua A · Larned, KSBuilt 1973 · S/N 73-30535 N1261SRed Arrows Aviation LLC · Lakeway, TXBuilt 1976 · S/N 18264829 N1262MRtw Aviation LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1975 · S/N 18264265 N1262RKullmann Richard · Encinitas, CAS/N 4336 N1262SSopatyk Brian D · Boise, IDBuilt 1976 · S/N 18264830 N12633East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N 2015 N1263SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264831 N1264ZStellaire Alliance LLC · Fort Worth, TXBuilt 1961 · S/N D-6728 N1265CDbg Aviation · Roscoe, ILBuilt 2003 · S/N 1291 N1265SColeman Douglas · Ocean Springs, MSBuilt 1976 · S/N 18264833 N1265ZGertsen Ronald H · Glenwood, NJBuilt 1961 · S/N TC-111 N1266MBeta Flight LLC · Queen Creek, AZS/N 33701266 N1266PArnold Aviation Ltd · Minster, OHBuilt 2006 · S/N 41637 N1266RObowa James K · Lino Lakes, MNBuilt 1972 · S/N 30431 N1266SBarton Jonathan E · Tehachapi, CABuilt 1976 · S/N 18264834 N1266YVerona Equipment LLC · Verona, KYBuilt 2006 · S/N 41587

Back to AD 2000-23-21