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.

N1313BSwanland Robert C · San Jose, CABuilt 1958 · S/N 4072 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440 N1313XM & S Airsupply DBA · Hawthorne, CAS/N 4223 N1314CDajczak Stanislaw P · Findlay, OHBuilt 2003 · S/N 0502 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N1314ZGensler Jordan T · Three Lakes, WIBuilt 1961 · S/N D-6746 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123 N1316RAirgo Partners LLC · Lititz, PABuilt 1968 · S/N E-125 N1316ZN1316zulu LLC · Defiance, OHBuilt 1961 · S/N D-6749 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N1319ZGood Steven D · Douglas, WYBuilt 1961 · S/N D-6757 N131AMAmis Benjamin · Austin, TXBuilt 2007 · S/N 2865 N131CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 1031 N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393 N131DXRegistered aircraftBuilt 2020 · S/N 2059 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N131EAEagle X LLC · Chamblee, GABuilt 2006 · S/N 2239 N131EGEdgo Flying Inc · Naperville, ILBuilt 2002 · S/N 1248 N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538 N131HPrentice Robert D · Ripon, WIBuilt 1957 · S/N 4041 N131HFMeridian Transport LLC · Wilmington, DEBuilt 2017 · S/N 1525 N131JKJsk Aviation LLC · Little Rock, ARBuilt 2026 · S/N 11264 N131KMKeriair LLC · Point Pleasant, NJBuilt 2025 · S/N 10657 N131LTAlpha Mike Foxtrot Logistics LLC · Las Cruces, NMBuilt 2012 · S/N 0300 N131MADesert Eagle Aviation LLC · Albuquerque, NMBuilt 2001 · S/N 30-0059 N131MDWoodley Aerial Leasing LLC · Walnut, ILBuilt 1959 · S/N D-5978 N131MGHarrison Simon M · Libertyville, ILBuilt 2007 · S/N 2830 N131MKJeffrey Robert D · Chandler, AZFirst renewal noticeBuilt 2008 · S/N LS-221 N131MWFarina George · Killen, ALBuilt 2004 · S/N 41021 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N131SRValiair Limited Company Trustee · Casper, WYBuilt 2006 · S/N 1887 N131TJPryor Mountain Aviation LLC · Cody, WYBuilt 2009 · S/N 3449 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963 N131YBeli Christopher J · Oregon, OHS/N 18052073 N1320SInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 18264884 N1321CClark Charles G · Catlettsburg, KYBuilt 2006 · S/N 42517 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701 N1321SKibler Ronald P · Kennesaw, GABuilt 1976 · S/N 18264885 N1322FHoffman Michael J · Bethel, AKBuilt 1975 · S/N 18502825 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N1322LPfendt Anton N · Spring, TXBuilt 2001 · S/N 0022

Back to AD 2000-23-21