Registered aircraft · 47,133

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.

N456ADStafford Arthur · Oak Bluffs, MABuilt 1996 · S/N E-3026 N456AKAccelerated Construction LLC · La Grande, ORBuilt 2008 · S/N 1979 N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252 N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717 N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298 N456CRMcevoy Richard D Trustee · Anchorage, AKBuilt 1977 · S/N R1722756 N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676 N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525 N456DHWilliams Metal And Machinery LLC · Irvington, ALS/N 21058042 N456DLGt Aviation LLC · Mountain Home, ARBuilt 1972 · S/N TC-1461 N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378 N456DRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N 1247 N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896 N456GXBruschi Dale Alan · Hollywood, FLBuilt 2006 · S/N 29-0461 N456HWestwind Inc · Marina, CABuilt 1951 · S/N NAV-4-2228-B N456HTDumbo II LLC · Omaha, NEBuilt 2016 · S/N 1371 N456JGGronemeyer Jens · Deland, FLS/N 18264380 N456JMLandmark Aviation Services LLC · Sarasota, FLBuilt 1974 · S/N 340-0535 N456KGDesk Aviation Inc · Las Vegas, NVBuilt 2022 · S/N 8979 N456KMKilo Mike Aviation LLC · Chandler, AZBuilt 2006 · S/N 1977 N456KPNorthern Arizona Renal Aviation LLC · Flagstaff, AZBuilt 1991 · S/N CE-1597 N456KWQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N TJ-427 N456LBPhoenix Aviation LLC · Dover, DEBuilt 2014 · S/N 2256 N456LEAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1868 N456LL2fly-Safety LLC Trustee · Azle, TXBuilt 2008 · S/N 3009 N456MGJones Daniel S Trustee · Hendersonville, NCBuilt 2008 · S/N 3330 N456MPAhgl LLC · San Diego, CABuilt 2004 · S/N 287 N456PSGaston Trevino Jr · Brownsville, TXBuilt 2004 · S/N 29-0335 N456PWMilnar Greg · New Richmond, WIBuilt 2003 · S/N 1IV-446 N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314 N456SSPowell Deidre · Santa Monica, CABuilt 2006 · S/N 1676 N456STMcbride Ken · San Martin, CABuilt 1975 · S/N 414-0810 N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625 N456WPrez Carl · San Antonio, TXBuilt 1980 · S/N 28R-8131061 N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766 N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390 N4570ATamkin Steven M · Malibu, CABuilt 2006 · S/N 1717 N4570CFairbanks Investor LLC · Fairbanks, AKBuilt 1956 · S/N 25514 N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220 N4571BSchumacher Eraine · Hague, NDBuilt 1955 · S/N 31470 N4571CBlair Whitney · Temecula, CAS/N 25-0495 N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150 N4572BPagel Jeffrey · Wasilla, AKBuilt 1955 · S/N 31471 N4572FRichards Stewart G · North Palm Beach, FLBuilt 1966 · S/N 185-1079 N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744 N4573FNapflin Erich P · Wasilla, AKBuilt 1966 · S/N 185-1080 N4574FKlingenmeyer Korey L · Anchorage, AKBuilt 1966 · S/N 185-1081 N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118 N4574XClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 34-7670075 N4575BKrupinshi Floyd M · Chugiak, AKBuilt 1955 · S/N 31474

Back to AD 2000-23-21