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.

N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787 N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587 N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788 N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588 N2488TForsberg Edwin Eugene · Elk Grove, CABuilt 1962 · S/N NAV-4-2488 N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388 N2489CRegistered aircraftBuilt 1954 · S/N 30789 N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789 N2489TMoore Robert C · Edison, CABuilt 1962 · S/N NAV-4-2489 N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389 N248APRegistered aircraftBuilt 2006 · S/N 42541 N248ASLlama Cirrus LLC · Concord, MABuilt 2017 · S/N 4537 N248CDTroiano Mark Q · Port Orange, FLBuilt 2001 · S/N 1148 N248CGStahura Conveyor Products Inc · Lewisville, NCBuilt 2001 · S/N 0092 N248CPSomerville Derek J · Murray, KYBuilt 2006 · S/N 1736 N248CRDirect Path Flight Services LLC · Bingham Farms, MIBuilt 2023 · S/N 9126 N248DDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N TE-171 N248DGWhinery Kevin D · La Habra, CABuilt 2005 · S/N 1359 N248DMMontana 248dm LLC · Kalispell, MTBuilt 2002 · S/N 0374 N248GFollett Enterprises LLC · Vlg Of Lakewd, ILBuilt 2005 · S/N 1261 N248HRidge Line Aviation LLC · Denver, COBuilt 1975 · S/N 6080C N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726 N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124 N248JTRegistered aircraftBuilt 2025 · S/N 10905 N248KMAutomated Ag Systems LLC · Moses Lake, WABuilt 2016 · S/N 1458 N248LFLima Foxtrot Inc · San Rafael, CABuilt 2020 · S/N 2128 N248LKTwelve Forty-Eight Aviation LLC · Camden, DEBuilt 2025 · S/N 10819 N248LTOconnell Christopher · Tucson, AZBuilt 1975 · S/N 34-7570019 N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558 N248PCTrident Aircraft Inc · Easton, MDBuilt 2015 · S/N 2287 N248PZPapa Zulu LLC · Belmont, MABuilt 2025 · S/N 10569 N248RGVisionx Transportation Inc · Glendale, CABuilt 2015 · S/N 2277 N248RPPatterson Robert F · Buckley, WABuilt 1958 · S/N FM84-1 N248SHWaldron Aviation LLC · Fort Lauderdale, FLBuilt 2002 · S/N 0146 N248SPStallion Paving LLC · Austin, TXBuilt 2025 · S/N 10519 N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590 N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390 N2491GShowah Christopher Douglas · Indianola, MSS/N 51791 N2491QLong Daniel · Stevenson, ALBuilt 1966 · S/N 18257691 N2491RDaly John M · Fort Worth, TXBuilt 1964 · S/N 18255591 N2491SGeorge Ladelle L · Ashley, NDBuilt 1967 · S/N 337-0791 N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391 N2492CTjossem Martin O · Paullina, IABuilt 1954 · S/N 30792 N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302 N2492YBenham Charles D · San Angelo, TXBuilt 1968 · S/N E-74 N2493CBallard Bradley J · Youngsville, NCBuilt 1954 · S/N 30793 N2493QTarrant Enterprises Inc · Eagle, COBuilt 1966 · S/N 18257693 N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393 N2494EDuran Louis · Chino, CABuilt 1982 · S/N 18268207 N2494QMcculloch Kyle · Bixby, OKBuilt 1966 · S/N 18257694

Back to AD 2000-23-21