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.

N6679XElite Aviation Group LLC · Pasco, WABuilt 1982 · S/N E-2041 N6679YRanchlands LLC · Hyattville, WYBuilt 1988 · S/N E-2445 N667CCAeromont LLC · Billings, MTBuilt 2003 · S/N BB-1827 N667FEFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 771 N667WJConnell Blue LLC · Berkeley Heights, NJBuilt 2004 · S/N 258667 N667XLAircraft Leasing And Sales Inc · Wichita, KSBuilt 2006 · S/N 560-5667 N66801Cirrus Management LLC · Suwanee, GABuilt 1979 · S/N E-1603 N66803United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42817 N66805Opa Aviation LLC · Littleton, NCBuilt 1980 · S/N TH-1081 N66808United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42820 N66812Dehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1604 N66814United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42745 N66815Circle S Aviation LLC · Missoula, MTS/N E-2083 N6681LRotary Industries Inc · Miami, FLBuilt 1979 · S/N TH-1088 N6681SN6681s LLC · Helena, MTBuilt 1979 · S/N LJ-850 N66825United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42748 N66828United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44580 N6682ZDavis Brad L Trustee · Canton, MOBuilt 1979 · S/N E-1607 N66831United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44562 N66837United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60122 N6683WWest Dakota Flight Co LLC · Miles City, MTS/N BB-1154 N66840Lowery Aviation LLC · Burwell, NEBuilt 1983 · S/N E-2085 N66841United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42182 N66848United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42188 N66849Hawk Aircraft Sales And Leasing LLC · Sterling Heights, MIBuilt 1979 · S/N TH-1092 N6684DDowney Leasing LLC · Lexington, NEBuilt 1979 · S/N E-1610 N6684VFba Leasing LLC · Mountain Brk, ALS/N TH-1089 N66863Taylor John Arthur · Mission Hills, KSBuilt 1983 · S/N E-2086 N6686DN6686d LLC · Idaho Springs, COBuilt 1979 · S/N TH-1097 N6686XCoughlin James G · Naples, FLBuilt 1979 · S/N E-1616 N66878Cool Blue Air LLC · Wilmington, DEBuilt 1979 · S/N TH-1100 N66893United Airlines Inc · Chicago, ILBuilt 2016 · S/N 42197 N66896Diesbach Benjamin · Cincinnati, OHBuilt 1979 · S/N E-1623 N66897United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62814 N6689NMoore Christopher J · Mebane, NCBuilt 1979 · S/N E-1622 N668EEFlying Journey LLC · El Monte, CABuilt 1999 · S/N 525-0343 N668FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 772 N668JGCapps Steven M · Mount Pleasant, TXBuilt 1999 · S/N E3266 N6690GKey Lime Real Estate Inc · Lutz, FLBuilt 1979 · S/N E-1625 N6690YThree Green LLC · Towanda, KSBuilt 1979 · S/N E-1627 N66913Mp Air LLC · Stonewall, LABuilt 1979 · S/N E-1631 N66918Lbc1 LLC · Mount Olive, NCBuilt 1980 · S/N TH-1104 N66919Gta Air Inc · Addison, TXBuilt 1979 · S/N E-1634 N66928International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N E-1628 N6692DWisodak Air LLC · Eau Claire, WIBuilt 1984 · S/N LJ-1072 N66932Worstell Kris D · Gordonville, TXBuilt 1979 · S/N E-1630 N6695DExtrusions Inc · Fort Scott, KSBuilt 1980 · S/N E-1657 N6696DMayfly Aviation LLC · Quincy, FLBuilt 1980 · S/N E-1636 N6696YAlcri Inc · Lewes, DES/N E-1639 N669FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 774

Back to AD 2006-16-18 R1