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.

N619PFDel Ag Aero LLC · Milton, DEBuilt 2015 · S/N 802A-0619 N62370Bell Flying Inc · Newport, ARBuilt 2019 · S/N 802A-0787 N623BFHiggins Leasing Inc · The Woodlands, TXBuilt 2020 · S/N 802A-0827 N624BFBrb LLC · Lewes, DEBuilt 2022 · S/N 802A-0934 N625BFBrb LLC · Lewes, DEBuilt 2024 · S/N 802A-1086 N62764Bell Flying Inc · Newport, ARBuilt 2020 · S/N 802A-0859 N627LANew Frontier Aviation LLC · Fort Benton, MTBuilt 2005 · S/N 802A-0213 N628FAAkbj LLC · Lewes, DES/N 802A-0641 N629JPLj Leasing LLC · Cardington, OHBuilt 2002 · S/N 802A-0129 N639LAJ & R Flying Service LLC · Alicia, ARBuilt 2016 · S/N 802A-0639 N63AWAmerican Ag Aviation Inc · Five Points, CABuilt 1998 · S/N 802A-0063 N641SMRiverside Air LLC · Shelby, MSBuilt 2023 · S/N 802A-1064 N661MAAramco Capital Company LLC · DhahranBuilt 1998 · S/N 802A-0057 N662MAAramco Capital Company LLC · DhahranBuilt 1996 · S/N 802-0037 N663MAAramco Capital Company LLC · DhahranBuilt 2014 · S/N 802-0552 N665UHartley Flying Service Inc · Stuttgart, ARBuilt 2019 · S/N 802A-0783 N670BFBrb LLC · Lewes, DEBuilt 2025 · S/N 802A-1214 N670RBOver The Top Aviation Inc · Jonesboro, ARBuilt 2021 · S/N 802A-0875 N672LAGarrett Flying Service Inc · Danbury, TXBuilt 2021 · S/N 802A-0926 N674LAFerriday Flying Service Inc · Ferriday, LABuilt 2018 · S/N 802A-0774 N67AGA & L Farm Services Inc · Helena, ARFirst renewal noticeBuilt 2017 · S/N 802-0686 N684LARegistered aircraftBuilt 2017 · S/N 802A-0684 N687LA5g'S Aviation LLC · Trumann, ARBuilt 2017 · S/N 802A-0687 N69FYTexoma Ag LLC · Corsica, SDBuilt 2023 · S/N 802A-1015 N69VCPro Agri Spraying Service Inc · Ropesville, TXBuilt 2022 · S/N 802A-0945 N703NAMcelwain Russell · Lancaster, KSBuilt 2024 · S/N 802A-1133 N711FUNeal Aircraft Inc · Slaton, TXBuilt 2016 · S/N 802A-0650 N711NACkw Aviation LLC · Dalhart, TXBuilt 2025 · S/N 802A-1202 N716FAFarm Air Corp · Minturn, ARBuilt 2014 · S/N 802A-0576 N717DAAero Spray Inc DBA · Appleton, MNBuilt 2008 · S/N 802A-0303 N718MLRice Flying LLC · Poplar Bluff, MOBuilt 2020 · S/N 802-0830 N71BMEvergreen Flying Service Inc · Dover, DES/N 802A-1271 N71HKSak IV LLC · Brookings, SDBuilt 2025 · S/N 802A-1186 N721LAAir Repair Inc · Cleveland, MSBuilt 2017 · S/N 802A-0721 N726RLLassco LLC · Middletown, DEBuilt 2023 · S/N 802-1019 N729CFWells Flying Services LLC · Holdrege, NEBuilt 2000 · S/N 802A-0101 N729LARice Flying LLC · Corning, ARBuilt 2017 · S/N 802-0729 N729PFRtc Aviation LLC · Munday, TXBuilt 2020 · S/N 802A-0857 N731TJDcs Air LLC · Lewes, DEBuilt 2017 · S/N 802A-0731 N740LALissie Flying Service Inc · Lissie, TXBuilt 2018 · S/N 802A-0780 N745LAKlein Flying Service Inc · Lawrenceville, ILBuilt 2018 · S/N 802A-0745 N746LAAnderson Farming Co · East Bernard, TXBuilt 2020 · S/N 802A-0828 N750LAWestwind Air LLC · Lake Village, ARBuilt 2022 · S/N 802A-0995 N753FAFarm Air Corp · Hoxie, ARBuilt 2013 · S/N 802A-0531 N754LAC & L Holzwarth Inc · Virden, ILBuilt 2018 · S/N 802A-0770 N758LALowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 802A-1103 N767WPWestern Pilot Services Inc · League City, TXS/N 802A-0688 N7742LBcm Flying Inc · Shelby, MSBuilt 2017 · S/N 802A-0693 N776ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 802A-0648 N779DAAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802A-0779

Back to AD 2010-17-18 R1