Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N13KDWoelbing Aviation LLC · Franksville, WIBuilt 1979 · S/N 501-0119 N13PGJohnston Steven P · Coto De Caza, CABuilt 1976 · S/N 421C0031 N13RKSwartz Charles Harris Jr · Spicewood, TXBuilt 1978 · S/N E-1238 N13STN7880l LLC · Port Charlotte, FLBuilt 1978 · S/N 501-0285 N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468 N13YZCreative Destination Development LLC · Mount Pleasant, TXBuilt 1976 · S/N E-859 N13ZZTigerair Of Alabama Inc · Newark, DEBuilt 1973 · S/N E-464 N1400MGainesville Aircraft Sales Inc · Gainesville, FLS/N 650-0140 N140ASAircraft Structures International Corp · Enid, OKS/N 208B0633 N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753 N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140 N140RFAv Serv LLC · Dover, DES/N 208B0656 N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155 N140TSInch & Co Aviation LLC · York, PAS/N 650-0141 N140UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0823 N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195 N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306 N141GLSpring Branch Water Well Service W Texas Div Inc · Fort Stockton, TXBuilt 1979 · S/N 421C0628 N141HPBrankin Enterprises Inc · Dover, DES/N E-1815 N141LVictor One Four One LLC · Boston, MABuilt 2007 · S/N FL-524 N141PCCleggs Termite And Pest Control · Morehead City, NCS/N TH-2091 N141RFRandigo LLC · Wilmington, DEBuilt 1986 · S/N 20800105 N141SLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 306-141 N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23 N141SULynch Family Companies Inc · Waucoma, IABuilt 2022 · S/N FL-1308 N141UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0824 N141WEOmega Air Inc · San Antonio, TXS/N 46661 N141ZUsda Forest Service · Boise, IDBuilt 1984 · S/N 803 N14214United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28774 N14219United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28781 N1421MClausen Johan Robert · Las Vegas, NVBuilt 1976 · S/N 421C0106 N14228United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28792 N14230United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28794 N14231United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28795 N14235United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28947 N14237United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28802 N14240United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28952 N14242United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28805 N14249United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28809 N14250United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28957 N142DRHj & L Air LLC · Sacramento, CABuilt 1985 · S/N TH-1458 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N142RNNelson Robert J · Carbondale, ILBuilt 1948 · S/N D-1353 N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693 N142SAMonarch Enterprises Inc · Kirkland, WABuilt 1969 · S/N 241 N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841 N142UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0825 N143CAHaugland Group Aviation LLC · Melville, NYBuilt 2019 · S/N 208B5516 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585

Back to AD 2006-16-18 R1