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.

N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N121DSongbird Aviation LLC · Larkspur, CABuilt 1984 · S/N CE-1033 N121DAIron Air LLC · Saint Albans, MOBuilt 2021 · S/N 2383 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121EDLarry K Brown · Round Rock, TXBuilt 1979 · S/N 80-30969 N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765 N121EMRegistration Pending · Austin, TXRegistration pendingBuilt 1966 · S/N 18257784 N121EPInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 2812 N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353 N121GAWood David J · Lincolnshire, ILBuilt 2005 · S/N 1443 N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62 N121GPTaft Diversified LLC · Springfield, ILBuilt 1985 · S/N 46-8508086 N121HCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 0277 N121HPPk Flyer LLC · Lancaster, CABuilt 1956 · S/N 3643 N121HTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0794 N121JBRegistered aircraftBuilt 2021 · S/N 2484 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N121KPBennett Lumber Products Inc · Princeton, IDBuilt 2022 · S/N 8955 N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624 N121PAN121pa LLC · Kalispell, MTBuilt 2019 · S/N 32-0010 N121PCC&N Holding Corp · Spicewood, TXBuilt 2025 · S/N 10932 N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388 N121PHThurlow Daniel R · Parker, COBuilt 2019 · S/N 33-0018 N121PWAlbatross Aviation LLC · Greenwich, CTBuilt 2025 · S/N 10747 N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660 N121RBBergmanone LLC · Vandalia, OHBuilt 2021 · S/N 5079 N121RDVickery Forest H · Tallahassee, FLS/N 18052053 N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735 N121RPJohn A Rossi Inc · West Chester, PABuilt 1998 · S/N 29-0141 N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296 N121TBRecovery Room LLC · Smyrna, GABuilt 2006 · S/N 42540 N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435 N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340 N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359 N121YZAlart N121yz LLC · Eden Prairie, MNS/N 1948 N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N1220KOrion Equipment Leasing LLC · Stockbridge, GABuilt 2006 · S/N 1840 N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246 N1221VLovely John E · Rich Creek, VABuilt 1976 · S/N R1722145 N1221ZRegistered aircraftBuilt 2021 · S/N 5106 N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784 N1222GNational Aerotech Aviation Delaware Inc · Wilmington, DES/N 42554 N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276 N1223ARegistered aircraftBuilt 2008 · S/N 2922 N1223Z2dwh LLC · Katy, TXBuilt 1961 · S/N TC-67

Back to AD 2000-23-21