Registered aircraft · 686

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:2010-17-18-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:2010-17-18-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:2010-17-18-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:2010-17-18-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:2010-17-18-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:2010-17-18-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.

N90802Ag Air LLC · Washington, IABuilt 2000 · S/N 802A-0092 N909TATunica Air Inc · Tunica, MSBuilt 2020 · S/N 802A-0866 N90WWAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802-0489 N91092Wakefield Aircraft LLC · Cooperstown, NDBuilt 1993 · S/N 802A-0005 N91099Henderson Ag Service Inc · Osceola, ARBuilt 2024 · S/N 802A-1165 N9119BWoodley Aerial Leasing LLC · Walnut, ILBuilt 2000 · S/N 802-0100 N911BTAaa Aviation LLC · Donalsonville, GABuilt 2018 · S/N 802-0771 N911CRCedar Ridge Aviation LLC · Knox City, TXBuilt 2025 · S/N 802-1264 N911PLAir Xpress LLC · Wilmington, DEBuilt 2019 · S/N 802A-0805 N91357Wilde Air Service LLC · Volga, SDBuilt 2000 · S/N 802A-0107 N91358Kubecka Daniel P · Edna, TXBuilt 2001 · S/N 802A-0109 N9135FRba LLC · Kimberly, IDBuilt 2001 · S/N 802A-0117 N91398Tri-Air Farms LLC · Mamou, LABuilt 2001 · S/N 802A-0111 N913LLBoedeker Flying Service East LLC · Childress, TXBuilt 2022 · S/N 802A-0988 N914RARegistered aircraftBuilt 2021 · S/N 802A-0879 N915RAB&S Air Inc · Lumpkin, GABuilt 2019 · S/N 802A-0809 N917JBNick'S Flying Service Inc · Lagrange, INBuilt 2018 · S/N 802A-0769 N917RARegistered aircraftBuilt 2024 · S/N 802A-1174 N91959Aslesen Leasin LLC · Halstad, MNBuilt 1994 · S/N 802A-0008 N927BSB&S Air Inc · Lumpkin, GABuilt 2022 · S/N 802A-0973 N928BABrekke Aviation Inc · Edmore, NDBuilt 2018 · S/N 802A-0754 N928SMFirst State Ag Air Inc · Viola, DEBuilt 2012 · S/N 802A-0443 N941LARice Flying LLC · Poplar Bluff, MOBuilt 2022 · S/N 802-0941 N950HCRoma Air Corp · Belle Glade, FLS/N 802A-0233 N951FANeal Aircraft Inc · Slaton, TXBuilt 2014 · S/N 802A-0565 N953FAAir Support 1 Inc · Middletown, DES/N 802A-0585 N966FABoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802-0966 N968LAC & L Holtzworth Inc · Virden, ILBuilt 2022 · S/N 802A-0968 N969WPWestern Pilot Service Inc · League City, TXBuilt 2018 · S/N 802A-0757 N970LAC&L Holzwarth Inc · Virden, ILBuilt 2022 · S/N 802A-0970 N976NMKlondike Ag LLC · Nassau, DEBuilt 2021 · S/N 802A-0908 N977JBJb Leasing LLC · Norfolk, NEBuilt 2023 · S/N 802A-1038 N977RMBretts Spray Service Inc · Onida, SDBuilt 2017 · S/N 802-0702 N982ASAbove Standard Flying Service LLC · Tallulah, LABuilt 2023 · S/N 802A-1081 N983LALipan Creek Flying Service LLC · Eola, TXBuilt 2022 · S/N 802-0983 N993TATunica Air Inc · Tunica, MSBuilt 2017 · S/N 802A-0722

Back to AD 2010-17-18 R1