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.

N24EGParent Claude · Austin, TXBuilt 2020 · S/N 4877 N24EKMurphree Bridge Corp · Troy, ALBuilt 2008 · S/N TH-2248 N24ENEkman Co LLC · Chapin, SCBuilt 2019 · S/N 4769 N24EZGlenn Stuart G · Naperville, ILBuilt 1956 · S/N CG-154 N24FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N 18504207 N24GCGreene County Sports Parachute · Loretto, KYBuilt 1954 · S/N 31163 N24GHWilliams Mitchell L · Chickasha, OKBuilt 1963 · S/N TC-404 N24GKWheels Up LLC · Mesa, AZBuilt 2012 · S/N 0392 N24HLLederer Henry A IV · Riderwood, MDBuilt 1976 · S/N CE-660 N24HPYolo County/Yolo County Sheriffs Office · Woodland, CABuilt 1975 · S/N 18263568 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N24JCEllis Robert W · Gilbert, AZBuilt 1966 · S/N 18257607 N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337 N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265 N24KHMoffett Jules M DBA · Elmore, ALBuilt 1974 · S/N TE-996 N24KUKr Aircraft LLC · Clinton, MSBuilt 1999 · S/N 30-0038 N24KXGuiot Laurent P · Culver City, CABuilt 2015 · S/N 2278 N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503 N24LFPro Star Aircraft Sales LLC · Londonderry, NHBuilt 2023 · S/N 9549 N24LKPrime Rib Aviation LLC · Nowata, OKBuilt 1980 · S/N E-1744 N24MAMarsh Glen R · Williamson, GABuilt 1972 · S/N TC-1435 N24MWMn Aviation LLC · Dayton, OHBuilt 2011 · S/N 3758 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24PAJdf Equipment LLC · San Diego, CABuilt 2025 · S/N 10907 N24PXHornets Nest Aviation Inc · Farragut, TNBuilt 2006 · S/N LIV-502 N24PYMl Aero Inc Trustee · Wilmington, DEBuilt 2007 · S/N 42568 N24RAGrass Peter T · Hampstead, NCBuilt 1989 · S/N CE-1379 N24RCJeanes Guy R · Lampe, MOBuilt 1974 · S/N TE-994 N24REMelendez Jesus · North Miami, FLBuilt 1964 · S/N 18255274 N24RFAlatenn Construction & Properties LLC · Winchester, TNBuilt 2004 · S/N 1168 N24RHBurns Texas Enterprises Inc · Houston, TXBuilt 1971 · S/N 18260817 N24RMTittlemier Warren L · Ventura, CABuilt 1959 · S/N D-5805 N24SCGriffin Samuel C · Doniphan, MOBuilt 1977 · S/N U20603868 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N24TTStark Asset Leasing LLC · San Diego, CABuilt 2024 · S/N 10055 N24VCAlbertson & Davidson Llp · Mesa, AZBuilt 2024 · S/N 10058 N24VEDuke William Thomas · West Point, MSBuilt 1974 · S/N 18262869 N24VVWheels Up LLC · Land O Lakes, WIBuilt 1979 · S/N 18267131 N24WPost Mills Soaring Club · Norwich, VTBuilt 1966 · S/N 2014 N24WDVc Aviation LLC · Indianola, IABuilt 2022 · S/N 8717 N24WEPake Flying Services LLC · Felton, MNBuilt 1998 · S/N 3449071 N24WKCannizzaro Charles DBA · North Syracuse, NYBuilt 1967 · S/N D-8431 N24WWPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060884 N24XESofast LLC · Helena, MTBuilt 2013 · S/N LIV-510 N24YGMh Geriatrics LLC · Orlando, FLBuilt 2015 · S/N 1156 N24ZRodriguez-Botet Carlos R · Ben Wheeler, TXBuilt 1961 · S/N G-166 N2500MHenderson Craig B Trustee · Van Buren, ARBuilt 1982 · S/N 25-0681 N2500RN2500r LLC · Florence, SCBuilt 1967 · S/N 18258200 N2500TJ & C Holdings Inc · Laguna Beach, CABuilt 2004 · S/N 41026 N2501QEcological Flight Services LLC · Stuart, FLBuilt 1966 · S/N 18257701

Back to AD 2000-23-21