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.

N1005MAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1302 N10122Aero Spray Inc · Appleton, MNBuilt 2013 · S/N 802A-0495 N1041WRiverside Air LLC · Shelby, MSBuilt 2020 · S/N 802A-0858 N106LAVisser Ag Inc · Rigby, IDBuilt 2001 · S/N 802A-0106 N10TPAeronautical Technologies Inc · Clovis, NMBuilt 2006 · S/N 802-0246 N1101PJerry Price & Sons Inc · Joiner, ARBuilt 2024 · S/N 802A-1101 N1122RRegistered aircraftBuilt 2019 · S/N 802A-0794 N112FAFast Ag Air LLC · Watertown, SDBuilt 2025 · S/N 802A-1199 N115FARegistration Pending · Roseland, NERegistration pendingBuilt 2025 · S/N 802A-1250 N116FATesk Aviation LLC · Steele, MOBuilt 2025 · S/N 802A-1231 N11703Gsd Aerial LLC · O Neill, NEBuilt 2022 · S/N 802A-0949 N118AJCat Agri Aviation Inc · Walnut Ridge, ARBuilt 2009 · S/N 802A-0343 N119JWWestern Pilot Service Inc · League City, TXBuilt 2010 · S/N 802A-0383 N1255ABombero Aviation LLC · Childress, TXBuilt 2025 · S/N 802A-1255 N1255FLipan Creek Flying Service LLC · Eola, TXBuilt 2025 · S/N 802A-1241 N1263FF A I LLC · Marianna, ARBuilt 2026 · S/N 802A-1263 N127JWScott Cattle Company LLC · Burlington, COBuilt 2014 · S/N 802A-0553 N12DAAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802-0777 N130BMBoyds Aviation LLC · Rayville, LABuilt 2006 · S/N 802A-0249 N131LAThompson Flying Service LLC · Charleston, MOBuilt 2024 · S/N 802-1132 N147CAAkbj LLC · Lewes, DEBuilt 2023 · S/N 802-1008 N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002 N1546HAero Spray Inc DBA · Appleton, MNBuilt 1992 · S/N 802A-0003 N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157 N166LAAeronautical Technologies Inc · Clovis, NMBuilt 2004 · S/N 802A-0166 N169JTTidwell Flying Service Inc · Carlisle, ARBuilt 2014 · S/N 802A-0574 N173TANew Frontier Aviation LLC · Fort Benton, MTBuilt 2004 · S/N 802A-0178 N174MLNew Frontier Aviation LLC · Fort Benton, MTBuilt 2003 · S/N 802A-0168 N175LAMitchell Andrew D Trustee · Winnie, TXBuilt 2004 · S/N 802A-0175 N1802MMeyerkorth Aviation LLC · Rock Port, MOBuilt 2016 · S/N 802A-0678 N1802QPontiac Flying LLC · Pontiac, ILBuilt 2012 · S/N 802A-0484 N187LALocker Fred · Muleshoe, TXBuilt 2001 · S/N 802A-0108 N194BMBombero Aviation LLC · Childress, TXBuilt 2008 · S/N 802A-0283 N194CAAir Tractor Inc · Olney, TXS/N 802A-1350 N196CFAir Tractor Inc · Olney, TXS/N 802A-1277 N196LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0196 N20001Dcs Air LLC · Lewes, DEBuilt 2011 · S/N 802A0418 N2003YOops LLC · Cheyenne, WYBuilt 2011 · S/N 802A-0428 N200LAAsap Flying Service Inc · Hermiston, ORBuilt 2008 · S/N 802A-0292 N200WHDcs Air LLC · Lewes, DEBuilt 2018 · S/N 802A-0755 N2017NKen Grubbs Aero Inc · Harrisburg, ARBuilt 2011 · S/N 802A-0429 N2022BWil-Co Flying Service LLC · De Witt, ARBuilt 2011 · S/N 802A-0433 N2022QHartley Flying Service Inc · Stuttgart, ARBuilt 2011 · S/N 802A-0435 N2039YDelta Dusters LLC · Newellton, LABuilt 2011 · S/N 802A-0403 N205KCWalton Agwings Inc · Jonesboro, ARBuilt 2017 · S/N 802A-0728 N20607Neal Aircraft Inc · Slaton, TXBuilt 2012 · S/N 802A-0439 N2060HCleveland Air Service Inc · Cleveland, MSBuilt 2013 · S/N 802A-0497 N2060MAerial Crop Protection Inc · Stuart, FLBuilt 2012 · S/N 802A-0437 N2064JPadgett Ag Rotors LLC · Missoula, MTS/N 802-0450 N2065SSteggs Aerial Spraying Inc · Alva, OKBuilt 2012 · S/N 802A-0487

Back to AD 2002-15-06