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.

N8055HL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4055 N8057PMulder Air Inc · Renville, MNBuilt 2018 · S/N 802A-0778 N8057YL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2026 · S/N 802-4056 N8058LMontague Aviation LLC · Inverness, MSBuilt 2018 · S/N 802A-0743 N80595Standridge Flying Service Inc · Lake Village, ARBuilt 2025 · S/N 802A-1260 N805ASRice Flying LLC · Poplar Bluff, MOBuilt 2025 · S/N 802-1182 N805CBHog Air Aviation Inc · Paragould, ARBuilt 2016 · S/N 802A-0642 N805DGWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0156 N805ETArc Aviation Of Texas LLC · Winnie, TXBuilt 2012 · S/N 802A-0481 N805HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 802A-0570 N805KPTidwell Flying Service Inc · Carlisle, ARBuilt 2016 · S/N 802A-0673 N805NZHbair Co · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2017 · S/N 802A-0697 N805RXRegistration Pending · Norcross, MNRegistration pendingBuilt 2022 · S/N 802A-1001 N806BABombero Aviation LLC · Childress, TXBuilt 2016 · S/N 802-0644 N806EBDakota Air Spray LLC · Huron, SDBuilt 2013 · S/N 802A-0538 N806KPWild Rice Air Ag Inc · Rutland, NDBuilt 2017 · S/N 802A-0723 N806NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2018 · S/N 802A-0735 N807BBAgritec Aviation LLC · Deering, NDBuilt 2015 · S/N 802A-0584 N807HAAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2022 · S/N 802-0958 N807KPForest Flying Service Inc · Langdon, NDBuilt 2017 · S/N 802A-0730 N807NZHbair Co · Wilmington, DEBuilt 2017 · S/N 802A-0732 N807RXHog Air Aviation Inc · Paragould, ARBuilt 2023 · S/N 802A-1037 N808AMAero Seat Inc · Sterling, COS/N 802A-1275 N808HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2013 · S/N 802A-0498 N808NZTwin Eagles Aviation Inc · Fort Mohave, AZBuilt 2019 · S/N 802A-0793 N808RXHog Air Aviation Inc · Paragould, ARBuilt 2023 · S/N 802A-1056 N809BBBear Bayou Ag Service Inc · Middletown, DEBuilt 2023 · S/N 802A-1090 N809CBHbair Co · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2017 · S/N 802A-0709 N809KCMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2009 · S/N 802A-0347 N809NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2019 · S/N 802A-0789 N809RXAg Air Aircraft Inc · Paragould, ARBuilt 2023 · S/N 802A-1080 N80PFProducers Flying Inc · Louise, MSBuilt 2020 · S/N 802-0864 N810EBRegenald Michaud Aviation LLC · Willows, CABuilt 2018 · S/N 802A-0767 N810RXNeal Aircraft Inc · Slaton, TXBuilt 2023 · S/N 802A-1072 N811APRegistered aircraftBuilt 2020 · S/N 802A-0855 N811TPJ & J Air Service LLC · Jonesboro, ARBuilt 2019 · S/N 802A-0814 N812ASRice Flying LLC · Poplar Bluff, MOBuilt 2025 · S/N 802-1191 N812EBRice Flying LLC · Poplar Bluff, MOBuilt 2020 · S/N 802A-0867 N812KAHowatt Air Inc · Langdon, NDBuilt 2012 · S/N 802A-0480 N812NSTri Rotor Spray & Chemical Inc · Ulysses, KSBuilt 2008 · S/N 802A-0284 N813EBOld River Flying Service LLC · Helena, ARBuilt 2021 · S/N 802A-0929 N814ASBombero Aviation LLC · Childress, TXBuilt 2025 · S/N 802-1228 N814EBBlair Aviation LLC · Essex, MOBuilt 2022 · S/N 802A-0998 N814RXHog Air Aviation Inc · Paragould, ARBuilt 2024 · S/N 802A-1142 N815BABlair Aviation LLC · Essex, MOBuilt 2024 · S/N 802A-1097 N815RXHog Air Aviation Inc · Paragould, ARBuilt 2024 · S/N 802A-1153 N816BFBombero Aviation LLC · Childress, TXBuilt 2024 · S/N 802A-1164 N816DAAero Spray Inc DBA · Appleton, MNBuilt 2023 · S/N 802A-1013 N816EBBlair Aviation LLC · Essex, MOS/N 802A-1266 N816PAHangtime Investments LLC · Parma, MOBuilt 2018 · S/N 802A-0744

Back to AD 2010-17-18 R1