AD 2007-10-01

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
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.

N3087KBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 602-1264N310KPLowry Flying Service Inc · Grinnell, IABuilt 2013 · S/N 602-1232N312FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2020 · S/N 602-1312N319HCThree Flying Monkeys LLC · Sunray, TXBuilt 2017 · S/N 602-1286N325BGTurrell Flying Service Inc · Turrell, ARBuilt 2010 · S/N 602-1188N373FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2024 · S/N 602-1373N392FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 602-1392N392LAC&L Holzwarth Inc · Virden, ILBuilt 2025 · S/N 602-1391N392TMCentral Farmer'S Cooperative DBA · Ville Platte, LABuilt 2009 · S/N 602-1179N394TMWebb Flying Service Inc · Coy, ARBuilt 2016 · S/N 602-1279N398RKAir Worthy Inc · Lyon, MSBuilt 1998 · S/N 602-0484N4012JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2012 · S/N 602-1213N4025MSky Tech Inc · Dorchester, NES/N 602-1399N411GRLake Air Service LLC · Jennings, LABuilt 2002 · S/N 602-0642N411GSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 602-0466N41588Echo Fox Leasing LLC · Wilmington, DES/N 6021143N41600Patriot Ag Air LLC · Huntington, INBuilt 2010 · S/N 602-1187N41651Bank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 602-1164N419TWMidwest Agri Drone LLC · Saint Joseph, MOBuilt 2014 · S/N 602-1251N42022Central Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1169N4212JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2009 · S/N 602-1177N4217WAviation Flying Service · Greenwood, MSS/N 602-1180N422TWSug-Air LLC · Lubbock, TXBuilt 2016 · S/N 602-1278N424FSOver And Under Flying Service Inc · Knox, INBuilt 1997 · S/N 602-0424N42505Holloway Air Service Inc · Merigold, MSBuilt 2009 · S/N 602-1178N42590Twin County Air-Ag Inc · Winnie, TXBuilt 2009 · S/N 602-1181N437VADelta Air Inc · Belzoni, MSBuilt 2014 · S/N 602-1237N438LADownstown Airport Inc · Vineland, NJBuilt 2014 · S/N 602-1238N442MAMeyers Air Service LLC · Superior, NEBuilt 2022 · S/N 602-1337N4512JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2023 · S/N 602-1349N4515JLowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 602-1380N455PAMcginty Flying Service LLC · Jones, LABuilt 2006 · S/N 602-1141N456LAJaj Flying LLC · Sutton, NEBuilt 2005 · S/N 602-1131N4612JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2011 · S/N 602-1203N4712JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2013 · S/N 602-1225N496JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 602-1171N49PAState Exchange Bank · Lamont, OKS/N 602-0631N5003XJagco Inc · Middletown, DEBuilt 1998 · S/N 602-0488N50050Mowata Farms LLC · Mamou, LABuilt 1998 · S/N 602-0485N5005KFisher Spray Service LLC · Cardington, OHBuilt 1997 · S/N 602-0403N5006GBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 602-0416N5015KBirddog Aviation LLC · Stockton, KSS/N 602-0429N5021UReed Aviation Inc · Iota, LABuilt 1998 · S/N 602-0490N5043DSterling John A · Port Lavaca, TXS/N 602-0470N5045SAw Peterson Inc · Warren, MNBuilt 1997 · S/N 602-0423N5048DFitchs Flying Service LLC · Pearsall, TXBuilt 1998 · S/N 602-0469N50669Tri Rotor Spray And Chemical · Ulysses, KSBuilt 1997 · S/N 602-0447N5070HKubecka Operating Company Inc · Seminole, TXBuilt 1998 · S/N 602-0482N50738Farm Air Inc · Astoria, ILBuilt 1997 · S/N 602-0448N507FAGarrett Flying Service Inc · Danbury, TXBuilt 2014 · S/N 602-1247
Back to AD 2007-10-01