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.

N802YBS&H Aviation LLC · Robstown, TXBuilt 2022 · S/N 802A-0933 N802ZWWallin Michael L · Walnut Ridge, ARBuilt 2015 · S/N 802A-0591 N8033NAufderheide Flying Service Inc · Dewitt, ARBuilt 2017 · S/N 802A-0701 N8036ATensas Flying Service LLC · Saint Joseph, LABuilt 2018 · S/N 802A-0760 N8038VNeal Aircraft Inc · Slaton, TXBuilt 2018 · S/N 802A-0766 N80393Echo Fox Leasing LLC · Wilmington, DEBuilt 2018 · S/N 802A-0768 N8039JL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4053 N8039MSwing Wing Inc · Veedersburg, INBuilt 2023 · S/N 802A-1004 N803AALocker Fred · Muleshoe, TXBuilt 2012 · S/N 802A-0455 N803ARSparkys Aeronautical Holdings Inc · Dover, DEBuilt 2021 · S/N 802A-0893 N803ASRice Flying LLC · Poplar Bluff, MOBuilt 2024 · S/N 802-1096 N803CHTensas Aviation LLC · Lewes, DEBuilt 2022 · S/N 802A-0943 N803FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2022 · S/N 802A-0994 N803HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2016 · S/N 802A-0635 N803HMH And M Flyuing Service LLC · Osceola, ARBuilt 2019 · S/N 802A-0813 N803JFBff Aviation LLC · Paragould, ARBuilt 2013 · S/N 802A-0519 N803KAAnderson Flying Service LLC · Covington, TNBuilt 2022 · S/N 802-0955 N803KPT & M Aircraft LLC · Monticello, ILBuilt 2012 · S/N 802-0470 N803LMMorrison Lynn · Vernon, TXBuilt 2016 · S/N 802A-0663 N803MAG B Aerial Applications Inc · Slaton, TXBuilt 2000 · S/N 802A-0093 N803MSAir Tractor Inc · Olney, TXS/N 802A-1296 N803NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2016 · S/N 802A-0645 N803SEA & M Flying Service Inc · Carlisle, ARBuilt 2024 · S/N 802A-1166 N803VTesk Aviation LLC · Steele, MOBuilt 2024 · S/N 802A-1148 N8040GBaylee Company · Bear, DEBuilt 2024 · S/N 802A-1099 N8040LGregs Crop Care Co Inc · Wilbur, WABuilt 2017 · S/N 802A-0706 N80416Ckw Aviation LLC · Dalhart, TXBuilt 2023 · S/N 802A-1046 N8042YMorris Equipment LLC · Yuma, AZBuilt 2017 · S/N 802A-0691 N8043FMeyer Bros Ag LLC · Algona, IABuilt 2020 · S/N 802A-0820 N8046EAllard Evan Wade DBA · Vinita, OKBuilt 2016 · S/N 802A-0664 N8048RL3 Harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4054 N8049ABank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 802A-0790 N804AARice Flying LLC · Poplar Bluff, MOBuilt 2017 · S/N 802-0698 N804ASAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802A-0740 N804BFCkw Aviation LLC · Dalhart, TXBuilt 2019 · S/N 802A-0815 N804CTCottonwing Air LLC · Indianola, MSBuilt 2021 · S/N 802A-0919 N804DGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1999 · S/N 802A-0089 N804FARainey Aerial Ag Service Inc · Obion, TNBuilt 2024 · S/N 802-1150 N804HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2017 · S/N 802A-0710 N804HMH And M Flying Service LLC · Osceola, ARBuilt 2024 · S/N 802A-1105 N804KPAir-Worthy Inc · Lyon, MSBuilt 2013 · S/N 802A-0496 N804MANew Frontier Aviation LLC · Fort Benton, MTBuilt 1996 · S/N 802-0026 N804MWWoodard Flying Service Inc · Corning, ARBuilt 2022 · S/N 802A-0948 N804NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2017 · S/N 802A-0683 N804RATwist Air LLC · Turrell, ARBuilt 2015 · S/N 802A-0617 N804RXB&S Air Inc · Lumpkin, GABuilt 2019 · S/N 802A-0786 N804SESummer Agro Services LLC · Royal Palm Beach, FLBuilt 2025 · S/N 802A-1209 N804WWWhirlwind Aviation Inc · Fisher, ARBuilt 2016 · S/N 802A-0667 N8050UL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2017 · S/N 802-4030 N8050WL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4052

Back to AD 2010-17-18 R1