Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,798

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

N686CFAt Aero LLC · Wilmington, DEBuilt 1982 · S/N BB-1085 N686FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0804 N686FRVon Syke Orchards LLC · Anderson, SCBuilt 1979 · S/N TH-1015 N686JHHorton Aviation LLC · Tulsa, OKBuilt 2013 · S/N 525-0810 N686MEMachined Fixture Fabrication LLC · Burnsville, MNS/N E-3593 N686TXYour Jet LLC · Wilmington, DEBuilt 2004 · S/N 258686 N687FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0873 N687MMBuckeye Fluids LLC · Wilmington, DEBuilt 2002 · S/N LJ-1667 N687SBBallard Air LLC · Virginia Beach, VABuilt 2018 · S/N FL-1168 N68801United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42740 N68802United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42739 N68805United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42818 N68807United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42819 N68811United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42175 N68817United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42747 N68821United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43535 N68822United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42178 N68823United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42746 N6882MScuttle421 LLC · Sugar Land, TXS/N 421C1074 N68834United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44564 N68836United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60088 N68842United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42183 N68843United Airlines Inc · Chicago, ILBuilt 2015 · S/N 60317 N68880United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42199 N68891United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42196 N688FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0874 N688MCFlight Management LLC · Kirkland, WABuilt 2001 · S/N 20800347 N689ABCharney Air Inc · Wilmington, DES/N E2513 N689CAir Mt A36 LLC · Lake Havasu City, AZBuilt 2002 · S/N E-3461 N689EEWin Air LLC · Kalispell, MTBuilt 2020 · S/N FL-1237 N689EWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 5510421 N689FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0875 N689KAKamaka Air LLC · Honolulu, HIBuilt 2011 · S/N 208B2308 N689WTotal Prf LLC · Lewes, DEBuilt 1984 · S/N 650-0045 N68ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 258234 N68BQUnfinished Journey LLC · Dover, DEBuilt 1978 · S/N TH-952 N68CBCracker Barrel Old Country Store Inc · Lebanon, TNBuilt 1999 · S/N 258453 N68CHIntentional Air LLC · Brigham City, UTBuilt 2016 · S/N 525-0902 N68DKDago LLC · Mcallen, TXBuilt 1980 · S/N LA-56 N68KKC&J Aviationllc · Wichita, KSBuilt 2017 · S/N 525-0945 N68LULewis University · Romeoville, ILBuilt 1968 · S/N 163 N68MNGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1962 N68MP920 Redmond Leasing LLC · Wilmington, DEBuilt 1986 · S/N E-2320 N68MUPark Avenue Group Inc · Stuart, FLBuilt 1978 · S/N BE-37 N68WGInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N FL-840 N68YBCzzc Aviation LLC · Tucson, AZBuilt 1999 · S/N 290 N69Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-4 N69084Konen Rock Products Inc · Milton Freewater, ORBuilt 1982 · S/N LA-157 N690ESInternational Aviation Sales Ltd · Cleveland, OHBuilt 1995 · S/N 560-0336 N690FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0876

Back to AD 2006-16-18 R1