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.

N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564 N31291N31291 Aviation LLC · Omro, WIBuilt 1988 · S/N E-2432 N3129DHawgs Landing LLC · Warrensburg, MOBuilt 1955 · S/N 31927 N3129QUrbanowski Edward F · Paxton, MAS/N 18258129 N3129UJones Robert M · Brooksville, FLBuilt 1988 · S/N CE-1255 N312ABSmith Kenneth R · Senoia, GAFirst renewal noticeBuilt 1978 · S/N 28R-7803120 N312ADAltier Daniel T · Bloomfield Twp, MIBuilt 2005 · S/N 1615 N312AETwo Creek Capital LLC · Fayetteville, ARBuilt 2019 · S/N 4783 N312APAtish LLC · Hermosa Beach, CABuilt 2025 · S/N 10726 N312ARTime Machine Aviation LLC · Cleveland, TNBuilt 2015 · S/N 2284 N312CNN312cn LLC · Prescott, AZBuilt 1980 · S/N 28R-8031023 N312CPSsi Mechanical LLC · San Antonio, FLBuilt 2008 · S/N 3120 N312CRMjk Air LLC · Estes Park, COS/N E-23 N312CSFlybuys3 LLC · Lewes, DEBuilt 1977 · S/N 310R0959 N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204 N312DKline Robert H · Oley, PABuilt 2000 · S/N 29-0255 N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262 N312DD312dd LLC · Greenville, SCBuilt 2012 · S/N 2153 N312DXPowder Day Aviation LLC · Camden, DEBuilt 2020 · S/N 2113 N312DYParte Tercero LLC · Irvine, CABuilt 2023 · S/N 9225 N312FPEger Aviation LLC · Pittsburgh, PABuilt 2014 · S/N 4069 N312GEKalsi Pritpal · Clarksburg, MDBuilt 2012 · S/N 0383 N312GMSonas Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9370 N312GTKiser Consulting LLC · Atlanta, GABuilt 2022 · S/N 8920 N312HWdc Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 2193 N312JBBadmia LLC · Polk City, IAFirst renewal noticeBuilt 2002 · S/N 0373 N312JGJoule Resources LLC · Bellaire, TXBuilt 2006 · S/N 41691 N312KMBaer Ryan D · Missoula, MTBuilt 1957 · S/N 32846 N312MGMyles To Go Aviation LLC · Camden, DEBuilt 2019 · S/N 1874 N312MSGulf Of America Aviation LLC · Brookshire, TXBuilt 2023 · S/N 9185 N312MTP Mitchell LLC · Las Vegas, NVBuilt 2025 · S/N 10735 N312MXRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0033 N312NGNovember Golf LLC · Shamong, NJBuilt 2015 · S/N 4274 N312PXRauschenberger Ventures LLC · Chicago, ILBuilt 2021 · S/N 5014 N312REBlue Jay Family Office LLC · Wilmington, DEBuilt 2025 · S/N 11073 N312RKRjk Air LLC · Syracuse, NYBuilt 2016 · S/N 1370 N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474 N312SRStorm Consulting Enterprises LLC · Tyler, TXBuilt 2007 · S/N 2427 N312TJRau John M · S Coffeyville, OKS/N 023 N312TNUltimate Internet Access Inc · Wrightwood, CABuilt 2006 · S/N 31-0002 N312WG312wg LLC · Kenilworth, ILBuilt 2018 · S/N 1793 N312XXSilver State Skies LLC · Camden, DEBuilt 2022 · S/N 8925 N312ZFink Group LLC · Philadelphia, PABuilt 1960 · S/N CD-210 N31309Meadowlake Airpark LLC · Lenoir City, TNS/N TC-1524 N3130CUlrich Alex E · Atlanta, ILBuilt 1954 · S/N 30929 N3130FRoxy Aviation LLC · Bristol, RIBuilt 1966 · S/N 18257230 N3130QDobbs Peter J · Duluth, MNBuilt 1981 · S/N 18504322 N3130SN3130s Corporation · Wilmington, DEBuilt 1964 · S/N 18255630 N3130UW&J Aviation And Aerial Photography LLC · Brighton, MIBuilt 1963 · S/N 18254530 N3130WWarbirds East Inc · Fairhope, ALBuilt 1973 · S/N TC-1635

Back to AD 2000-23-21