Skip to content

Registered aircraft · 687

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

N20700Meyerkorth Aviation LLC · Rock Port, MOBuilt 2012 · S/N 802A-0486 N20718Cartillar Enterprises Inc · Wynne, ARS/N 802A-0465 N20726A&M Flying Service Inc · Carlisle, ARS/N 802A-0468 N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207 N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409 N211CHRegistered aircraftS/N 802A-1278 N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212 N212FBAero Spray Inc DBA · Appleton, MNBuilt 2010 · S/N 802A-0368 N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896 N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843 N226FBLipan Creek Flying Service LLC · Eola, TXBuilt 2024 · S/N 802A-1157 N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965 N22WHAeronautical Technologies Inc · Clovis, NMBuilt 1997 · S/N 802A0039 N23WTAeronautical Technologies Inc · Clovis, NMBuilt 2014 · S/N 802-0568 N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375 N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444 N257CAHorizon Air LLC · Lumpkin, GABuilt 2025 · S/N 802-1185 N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265 N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268 N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471 N272DAAero Spray Inc DBA · Appleton, MNBuilt 2025 · S/N 802-1258 N274BMEvergreen Flying Service Inc · Dover, DEBuilt 2026 · S/N 802A-1274 N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110 N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953 N288KWFarm Air Inc · Astoria, ILS/N 802A-1288 N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094 N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398 N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602 N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509 N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507 N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520 N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525 N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535 N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529 N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524 N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549 N30674Jlw Aviation Inc · Carlisle, ARBuilt 2014 · S/N 802A-0557 N30676Michaelis Gary DBA · Goodwin, ARBuilt 2014 · S/N 802A-0573 N3067JHartley Flying Service Inc · Stuttgart, ARBuilt 2014 · S/N 802A-0554 N3069SRoma Air Corp · Belle Glade, FLBuilt 2014 · S/N 802A-0559 N3070EG B Aerial Applications Inc · Slaton, TXBuilt 2014 · S/N 802A-0551 N3070FDakota Air Spray LLC · Huron, SDBuilt 2014 · S/N 802A-0577 N3072YAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0588 N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534 N307BRRice Flying LLC · Poplar Bluff, MOFirst renewal noticeBuilt 2017 · S/N 802-0718 N3082PCustom Air Inc · Roe, ARBuilt 2015 · S/N 802A-0600 N3082VMid Missouri Spray Service LLC · Richmond, MOBuilt 2015 · S/N 802A-0620 N3083KBoyds Aviation LLC · Rayville, LABuilt 2015 · S/N 802A-0618 N3083RAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0627 N3085QAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0628

Back to AD 2002-15-06