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.

N50013Georgeson Troy D · Drayton, NDS/N 401B-1012 N5006BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1996 · S/N 401B-1015 N5006KWoods Aviation LLC · Kearney, NEBuilt 1997 · S/N 402B-1024 N50071South Delta Aviation Inc · West Helena, ARBuilt 1996 · S/N 402B-1019 N5008LOlathe Spray Service Inc · Olathe, COBuilt 1996 · S/N 402B-1018 N5019YAir Sprayers Inc · Two Buttes, COS/N 402A-1071 N501JKBarjoseph Shirley · Chanute, KSS/N AT400-0482 N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059 N5028QTri Rotor Spray & Chemical · Ulysses, KSBuilt 1997 · S/N 401B-1028 N5034RMid Missouri Spray Service LLC · Richmond, MOBuilt 1996 · S/N 402B-1020 N5039FDixie Flying Service Inc · Gilliam, LABuilt 1997 · S/N 402A-1031 N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039 N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066 N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065 N5081WBarts Flying Service Inc · Storm Lake, IABuilt 1996 · S/N 401B-1013 N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047 N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041 N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043 N5120EC & L Holzwarth Inc · Virden, ILBuilt 1998 · S/N 402B-1052 N5124PIndependent Dusting Service Inc · El Campo, TXBuilt 1998 · S/N 402A-1051 N5128NBasin Aviation Inc · Rio Oso, CABuilt 1998 · S/N 402A-1054 N5175BMiller Aviation Inc · Norton, KSBuilt 1998 · S/N 402B-1084 N5191BBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 402A-1094 N5192FJohnson Airspray Inc · Argyle, MNBuilt 1999 · S/N 402A-1093 N5272TIndependent Dusting Service Inc · El Campo, TXBuilt 2022 · S/N 402B-1469 N527PKAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 402A-1067 N532BAAslesen Leasin LLC · Halstad, MNBuilt 2008 · S/N 402A-1200 N550GCSouth Delta Aviation LLC · Grace, MSBuilt 1997 · S/N 402A-1037 N56HFKeeter Jerry · Olney, TXBuilt 2005 · S/N 402B-1161 N598BAWestern Ag Aviation Inc · Plains, KSBuilt 2013 · S/N 402B-1272 N599BAWerth Lance · Johnson Lake, NEBuilt 2013 · S/N 402B-1302 N6000YA+ Aviation Services LLC · Goodland, KSBuilt 1995 · S/N 401B-0983 N60057Sunflower Aero Inc · Atwood, KSBuilt 1994 · S/N 401-0951 N6010UGray Ron · Hooker, OKBuilt 1995 · S/N 401B-0985 N601171 Lowflyer Inc · Harrisonville, MOBuilt 1994 · S/N 401B-0956 N6011TMichaelis Gary DBA · Palestine, ARBuilt 2011 · S/N 402B-1238 N6013GBlue Earth Flying Service LLC · Blue Earth, MNBuilt 1994 · S/N 401-0957 N60662Aura LLC · Zeeland, MIBuilt 1994 · S/N 402A-0968 N60679Shearer John · The Dalles, ORBuilt 1996 · S/N 402B-0997 N6072YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 0397 N6078WDakota Air Spray LLC · Huron, SDBuilt 1995 · S/N 402B-0972 N6081QPrinc Aviation LLC · Beloit, KSBuilt 1996 · S/N 402B-1001 N6082FHouston Ag Flying Service Inc · Owensboro, KYBuilt 1995 · S/N 402B-0974 N6082YDash Flying Service LLC · Chilton, WIBuilt 1980 · S/N 0273 N6099UBarajas Samuel · Mission, TXS/N 401B-0975 N6106URegistration Pending · Vernon, TXRegistration pendingBuilt 1995 · S/N 401B-0976 N61173L&M Decuir Inc · Cottonport, LABuilt 1996 · S/N 401B1003 N6128WWhitten Flying Service Equipment LLC · Snook, TXBuilt 1996 · S/N 402B-1002 N6139VRussel Armstrong & Danny Hawk DBA Onstott Dusters · Yuba City, CABuilt 1995 · S/N 402B-0982 N6146WAdara Aircraft LLC · Hamilton, MTS/N 401B-0979

Back to AD 2006-08-08 R1