Registered aircraft · 1,467

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:2001-10-04-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1') 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:2001-10-04-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1')
  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:2001-10-04-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1')
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.

N802BWBoedeker Flying Service West LLC · Childress, TXBuilt 2022 · S/N 802A-0939 N802CBR & W Flying Inc · Paragould, ARBuilt 2022 · S/N 802A-0962 N802CEArtic One LLC · Fairbanks, AKBuilt 2012 · S/N 802-0467 N802CGGb Aerial Applications Inc · Slaton, TXBuilt 2016 · S/N 802A-0675 N802CLKansas Farm And Ranch Inc · Seneca, KSBuilt 2017 · S/N 802A-0682 N802CRMeyer Bros Ag LLC DBA · Algona, IABuilt 2018 · S/N 802A-0772 N802CWAurora Cooperative Elevator Company · Aurora, NEBuilt 2000 · S/N 802A-0103 N802DAAero Spray Inc DBA · Appleton, MNBuilt 2020 · S/N 802A-0851 N802DFDungan Aerial Service Inc · Falmouth, INBuilt 2022 · S/N 802A-0937 N802DJKansas Farm And Ranch Inc · Seneca, KSBuilt 2013 · S/N 802A-0485 N802DKKroeplin Air LLC · Highmore, SDBuilt 2024 · S/N 802A-1114 N802DMRice Flying LLC · Poplar Bluff, MOBuilt 2009 · S/N 802-0338 N802DRAgri Air Industries Of Arkansas LLC · Paragould, ARBuilt 2020 · S/N 802-0838 N802DTThiel Air Care Inc · Chowchilla, CABuilt 2015 · S/N 802A-0590 N802DVMcgarity Flying Service LLC · Sikeston, MOBuilt 2021 · S/N 802A-0881 N802EAdams Aerial Solutions LLC · Decatur, ILBuilt 2018 · S/N 802A-0738 N802EBDakota Air Spray LLC · Huron, SDBuilt 2011 · S/N 802A-0430 N802EGEagle Lake Leasing LLC · Bradford, ARBuilt 2018 · S/N 802A-0739 N802EMMeyerkorth Aviation LLC · Rock Port, MOBuilt 2019 · S/N 802-0784 N802ETMid-State Aviation II Inc · Cozad, NEBuilt 2006 · S/N 802A-0225 N802FFoxtrot Air LLC · Highmore, SDBuilt 2014 · S/N 802A-0545 N802FFFlight Level Zero LLC · Othello, WABuilt 2025 · S/N 802A-1245 N802FUFlight Level Zero LLC · Othello, WABuilt 2021 · S/N 802A-0925 N802FYSlikker Flying Service Inc · Buttonwillow, CABuilt 2016 · S/N 802A-0676 N802FZBoardman Air Service LLC · Henderson, NEBuilt 2014 · S/N 802A-0578 N802GB&D Aircraft Leasing LLC · Waupun, WIBuilt 2017 · S/N 802A-0699 N802GBG B Aerial Applications Inc · Slaton, TXBuilt 2007 · S/N 802A-0257 N802GEDeby Ag Leasing · Wakarusa, INBuilt 2022 · S/N 802-0938 N802GKKurtz Rural Aviation LLC · Mound City, MOBuilt 2024 · S/N 802A-1094 N802HAPontiac Flying LLC · Pontiac, ILBuilt 2005 · S/N 802A-0197 N802HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 802A-0547 N802HCSouthern Aerial Service LLC · Douglas, GABuilt 2001 · S/N 802A-0112 N802HFBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 802A-0457 N802HJAir Support 1 Inc · Middletown, DEBuilt 2023 · S/N 802A-1002 N802HMAero S E A T Inc · Sterling, COBuilt 2003 · S/N 802-0146 N802HPMidwest Agri Drone LLC · Saint Joseph, MOBuilt 2020 · S/N 802A-0819 N802HRAg Concepts Inc · Morgan City, MSBuilt 2024 · S/N 802A-1091 N802HXHartley Flying Service Inc · Stuttgart, ARBuilt 2022 · S/N 802A-0950 N802JCrop Jet Aviation LLC · Gooding, IDBuilt 2010 · S/N 802A-0391 N802JCRba LLC · Kimberly, IDBuilt 2008 · S/N 802-0291 N802JEBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 802A-0961 N802JFMiles Flying Service Inc · Bono, ARBuilt 2015 · S/N 802-0623 N802JGFirst State Ag Air Inc · Viola, DEBuilt 2022 · S/N 802A-1003 N802JHRanch Aero LLC · Sterling City, TXBuilt 2012 · S/N 802A-0436 N802JJSummer Agro Services LLC · Royal Palm Beach, FLBuilt 2017 · S/N 802A-0719 N802JLBravo Ag Air LLC · Belmond, IABuilt 2014 · S/N 802A-0541 N802JPTumbleweed Leasing LLC · Tacoma, WABuilt 2000 · S/N 802A-0099 N802JTPonderosa Airtankers LLC · Safford, AZBuilt 2012 · S/N 802A-0447 N802JWRice Ag Service Inc · Brinkley, ARBuilt 2021 · S/N 802A-0927 N802KKroeplin Air LLC · Highmore, SDBuilt 2023 · S/N 802A-1026

Back to AD 2001-10-04 R1