Registered aircraft · 47,138

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.

N300HGHouchens Insurance Holdings Inc · Bowling Green, KYBuilt 2022 · S/N 8677 N300HMEngage Communication Inc · Aptos, CABuilt 2001 · S/N 40011 N300JNK-M Air Enterprises Inc · Corona, CABuilt 1973 · S/N TC-1634 N300JTMentor Capital LLC · San Antonio, TXBuilt 1978 · S/N 34-7970074 N300KKrakeel James A · Mount Pleasant, SCBuilt 1977 · S/N TE-1103 N300KM300 Knots Inc · Henderson, NVS/N LIV-420 N300KPRegistered aircraftBuilt 1979 · S/N TC-2240 N300MSChua Johann L · Daly City, CABuilt 1969 · S/N TE-688 N300NEBoone Steven E · Harrison, TNBuilt 1968 · S/N TC-1172 N300NVHolombo Lee C · Trenton, KYBuilt 2003 · S/N 40064 N300PJLegacy Of Speed LLC · Warsaw, INBuilt 1975 · S/N HC2A N300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382 N300RRRegan Richard Michael · Leesburg, VAS/N CE-177 N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074 N300SAWhalen Sean B · Naples, FLS/N CE-545 N300SQVortex Aviation LLC · Houston, TXBuilt 1979 · S/N 414A0416 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N300TLAlls Peyton H · Raleigh, NCBuilt 2003 · S/N 40067 N300TTDg Aero LLC · Little Rock, ARBuilt 1980 · S/N CE-906 N300YBGospel Ministries International Inc · Collegedale, TNBuilt 1986 · S/N 24-3010 N30100Jetstream Cowboys LLC · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870463 N3010LJones Johnny R · Thermopolis, WYBuilt 1965 · S/N 310J0010 N3010YPn4 Aviation Holdings LLC · Bishop, CABuilt 1979 · S/N 28R-7931151 N3011Hedrick Kirby L · Cora, WYBuilt 2023 · S/N 9617 N3011MMorcheid Louis W · Slickville, PABuilt 2006 · S/N 925 N3011TBranson West Development Inc · Paso Robles, CABuilt 1964 · S/N 320C0011 N3011YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1962 · S/N 18254011 N3012CHealy David Paul · Arlington, TXS/N D-5677 N3012HBonanza Two USA Inc Trustee · Wilmington, DEBuilt 1987 · S/N CE-1109 N3012TCain James W · Big Rapids, MIBuilt 1964 · S/N 320C0012 N3013FElwell David L · Coolidge, AZFirst renewal noticeBuilt 1966 · S/N 18257113 N3013YHolloway Gregory R · Brenham, TXBuilt 1962 · S/N 18254013 N3014EConstantine Carl A · Arroyo Grande, CABuilt 1982 · S/N 18268226 N3014FBrown Kimberly L · Tucson, AZBuilt 1966 · S/N 18257114 N3014QBilly B Services LLC · Cornelia, GABuilt 1967 · S/N 18258014 N3014WRunyan Joseph D · Bushnell, ILBuilt 1973 · S/N TE-933 N3015CSorna Douglas J · Flower Mound, TXBuilt 1958 · S/N D-5680 N3015WDl321 LLC · Lavon, TXBuilt 1973 · S/N TC-1594 N3015YBaines Larry R · Antioch, CABuilt 1962 · S/N 18254015 N3016CMoore Todd M · Peoria, ILBuilt 1958 · S/N D-5681 N3016FLosleben William L · Duvall, WABuilt 1966 · S/N 18257116 N3016QBarnes David L · Palmer, AKBuilt 1967 · S/N 18258016 N3016YWood James D · Mineral Bluff, GABuilt 1962 · S/N 18254016 N3017KSwing Paul M · Scottsdale, AZBuilt 1979 · S/N 28-7921048 N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520 N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118 N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018 N3018SPerez Daniel · Pembroke Pines, FLBuilt 1965 · S/N TC-960 N3018YGranger Airplane LLC · Granger, INBuilt 1962 · S/N 18254018 N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119

Back to AD 2000-23-21