Registered aircraft · 245

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

N10TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 602-1217 N114EPSilver Sky Ag Aviation LLC · Dumas, TXBuilt 1997 · S/N 602-0465 N116KPAtchley Joshua K DBA · Portageville, MOBuilt 2016 · S/N 602-1282 N116THMile High Aviation Inc · Yuma, COBuilt 2025 · S/N 602-1388 N119KPBig Windy Aviation Inc · Watson, ARBuilt 2019 · S/N 602-1305 N120KPPrairie Ag Service LLC · Des Arc, ARBuilt 2010 · S/N 602-1185 N121AAAg Air Inc · Matthews, MOBuilt 2020 · S/N 602-1310 N126LAMurdoch Aerial Spraying LLC · Nehawka, NEBuilt 2015 · S/N 602-1261 N128CMWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2020 · S/N 602-1309 N1290DSky Tech Inc · Dorchester, NEBuilt 2020 · S/N 602-1308 N132JWLowry Flying Service Inc · Grinnell, IABuilt 2008 · S/N 602-1156 N142BMAll In Flying Co · Wilmington, DEBuilt 2006 · S/N 602-1142 N145LADakota Air Spray LLC · Huron, SDBuilt 2006 · S/N 602-1145 N151LADownstown Airport Inc · Vineland, NJBuilt 2007 · S/N 602-1152 N155LALake Air Service LLC · Jennings, LABuilt 2007 · S/N 602-1149 N159LAWilmot Airplane Ventures LLC · Dover, DES/N 602-1159 N167LATowe Boys Agri Service Inc · Madison, ALBuilt 2008 · S/N 602-1167 N194LARtc Aviation LLC · Munday, TXBuilt 2018 · S/N 602-1294 N2003JCon Air LLC · Lake Providence, LABuilt 2011 · S/N 602-1204 N20062Lissie Flying Service Inc · Lissie, TXBuilt 2011 · S/N 602-1198 N2007A2007a LLC · Hastings, NEBuilt 2011 · S/N 602-1207 N2017FBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 602-1201 N203GHAurora Cooperative Elevator Co · Aurora, NEBuilt 2013 · S/N 602-1224 N20576Bain Aviation Inc · Nyssa, ORBuilt 2012 · S/N 602-1211 N2059CPro Agri Spraying Service Inc · Ropesville, TXBuilt 2011 · S/N 602-1206 N2061DAaa Aviation LLC · Donalsonville, GABuilt 2012 · S/N 602-1214 N2061LRoth Aerial Spraying LLC · Milford, NEBuilt 2012 · S/N 602-1216 N216TATailwinds Air Inc · Morganza, LABuilt 2013 · S/N 602-1227 N228DTGibbs Aviation Inc · Fremont, OHBuilt 2021 · S/N 602-1315 N2394RPalmer Flying Service Inc · Manito, ILBuilt 1999 · S/N 602-0545 N244LAWoodline Aviation LLC · Memphis, MOBuilt 2014 · S/N 602-1244 N257MSNeal Aircraft Inc · Slaton, TXBuilt 2023 · S/N 602-1350 N258LACrop First Aviation Inc · Stanfield, AZBuilt 2015 · S/N 602-1257 N259LAC & L Holzwarth Inc · Virden, ILBuilt 2015 · S/N 602-1265 N2602MWoodley Aerial Leasing · Walnut, ILBuilt 2002 · S/N 602-0645 N260LAGibbs Aviation Inc · Fremont, OHBuilt 2016 · S/N 602-1268 N263LACmk Aerial Inc · Sutton, NEBuilt 2015 · S/N 602-1263 N277ATBoardman Air Service LLC · Henderson, NEBuilt 2016 · S/N 602-1277 N282LAProp Ag LLC · Montezuma, KSBuilt 2012 · S/N 602-1215 N295DDJds Flying Service Inc · Glen Allan, MSBuilt 2018 · S/N 602-1295 N3017ZPlane LLC (The) · Grove, OKBuilt 2013 · S/N 602-1223 N3038AMoss Jimmy David DBA · Tillar, ARBuilt 2013 · S/N 602-1229 N3044FIowa On The Fly Inc · Fonda, IABuilt 2013 · S/N 602-1231 N30562J & D Aircraft LLC · Larimore, NDBuilt 2013 · S/N 602-1235 N3059NIowa On The Fly · Fonda, IABuilt 2013 · S/N 602-1236 N3065TCarroll Flying Service Inc · Lake Providence, LABuilt 2014 · S/N 602-1239 N3066NBoair Inc · Shaw, MSBuilt 2014 · S/N 602-1241 N3068BMccreary Flying Service LLC · Clarksdale, MSBuilt 2014 · S/N 602-1248 N3070N49 Flying Service LLC · Greenwood, MSBuilt 2014 · S/N 602-1250 N3079DNesom Waddell Cole · New Roads, LABuilt 2015 · S/N 602-1260

Back to AD 2007-10-01