Skip to content

AD 2006-08-08 R1

Registered aircraft · 257

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:2006-08-08-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:2006-08-08-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:2006-08-08-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:2006-08-08-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:2006-08-08-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:2006-08-08-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.

N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408 N23744Van Horne Robert E · Centralia, ILBuilt 1982 · S/N 400A-0429 N2393NMid Mo Ag Air LLC · Boonville, MOS/N 400-0441 N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240 N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400 N274ATBoardman Air Service LLC · Henderson, NEBuilt 2012 · S/N 402B-1251 N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281 N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201 N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199 N299JHJohnson Airspray Inc · Argyle, MNBuilt 1990 · S/N 4010726 N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276 N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283 N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284 N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305 N3070GWilliamsburg Air Service Inc · Kingstree, SCBuilt 2013 · S/N 402B-1303 N3160QAg Cat Applicators LLC · Avoca, TXBuilt 1982 · S/N 400-0477 N31626James Richard W · Chowchilla, CABuilt 1983 · S/N 400-0511 N3164BL & L Flying Inc · Glen Allan, MSBuilt 1984 · S/N 400-0513 N3166YDixie Crop Care Inc · Dixie, GABuilt 1984 · S/N 400-0515 N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814 N3652ZCotton Ag Inc · Walters, OKBuilt 1980 · S/N 400-0256 N3654GDixie Flying Service Inc · Bradley, ARS/N 400-0281 N3655TPutz Gary D · Hearne, TXS/N 301-0300 N3659NHoppe Air LLC · Beaman, IAS/N 400-0294 N39GJTri County Ag Service Inc · Ipswich, SDBuilt 1997 · S/N 401B-1023 N400XXAbernathy Spraying Service Inc · Tipton, OKBuilt 1986 · S/N 4000646 N401BMBart'S Flying Service Inc · Storm Lake, IABuilt 1992 · S/N 401-0853 N401CWDakotawild Aviation Inc · Westhope, NDBuilt 1992 · S/N 401-0870 N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813 N401NEBender Jace Edwin Fredrick · Humphrey, NEBuilt 1994 · S/N 401B0960 N401THAerial Ag Services LLC · Hillsboro, TXS/N 401-0875 N402CSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 402A-0816 N402CWThisius Flying Service Llp · Wells, MNBuilt 1998 · S/N 402A-1061 N402DEDeby Ag Leasing Lp · Wakarusa, INBuilt 1991 · S/N 402-0807 N402DGNorth Central Aviation LLC · Valentine, NEBuilt 1999 · S/N 402A-1091 N402FAgriculture Aviation Services LLC · Clarkfield, MNS/N 402A-1125 N402FHAasjng LLC · Holdrege, NES/N 402B-1254 N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151 N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117 N402JGWhalen Mark P · Millington, MDBuilt 2013 · S/N 402B-1277 N402JWKeahey Aviation LLC · West Monroe, LAS/N 402B-1249 N402KKKevin Kingsley LLC · Lamar, MOBuilt 2020 · S/N 402B-1430 N402LTBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 402B-1163 N402PRBarts Flying Service Inc · Storm Lake, IABuilt 2013 · S/N 402B-1282 N402REWhitten Flying Service Equipment LLC · Snook, TXBuilt 1997 · S/N 402A-1027 N402SKOli Grow LLC · Baskin, LAS/N 402-0895 N402SROli Grow LLC · Baskin, LABuilt 1994 · S/N 402-0939 N402TSunflower Aero Inc · Atwood, KSBuilt 1998 · S/N 402A-1060 N402TM402wd Holdings LLC · Corpus Christi, TXBuilt 2005 · S/N 402B-1164 N402TTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1304

Back to AD 2006-08-08 R1