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.

N360XNavecord Institute · Wilmington, DES/N BB-1783 N3611ASgmbb LLC · Seneca, SCBuilt 1979 · S/N E-1472 N3616Carter Machinery Co Inc · Salem, VABuilt 2001 · S/N 560-0571 N361BTextron Aviation Inc · Wichita, KSS/N FL-1391 N361BCGta Air Inc · Addison, TXS/N E1331 N361CAN361ca LLC · Wilmington, DEBuilt 2005 · S/N 258734 N361CMMesser-Bowers Co · Enid, OKBuilt 1986 · S/N E-2312 N361CWCk Aviation LLC · Brookhaven, MSBuilt 1980 · S/N E-1755 N361DEClear Sky Flying LLC · Center, TXBuilt 1985 · S/N 501-0687 N361DMLeibstein Guy · Babylon, NYBuilt 1975 · S/N E-670 N361EScience And Engineering Services LLC · Huntsville, ALBuilt 2024 · S/N FL-1345 N361EAAlcyone Trust Corp Trustee · Wichita, KSS/N BB-1103 N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741 N361LABest Friends Air LLC · Kerrville, TXBuilt 2001 · S/N 258562 N361MMJarrett Holdings LLC · Wink, TXBuilt 2002 · S/N FL-361 N361NYState Of New York · Albany, NYBuilt 2022 · S/N FL-1285 N361PJPremier Jets Inc · Hillsboro, ORBuilt 1974 · S/N 003 N361WHubbard Kenneth Scott · Decatur, ALBuilt 2002 · S/N E-3438 N36207United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30579 N3620MSanford Medical Center · Sioux Falls, SDBuilt 1991 · S/N BB-1396 N3621RBateman Randy · Lindale, TXBuilt 1977 · S/N E-1095 N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479 N36247United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28807 N36272United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31590 N36280United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31598 N362ARegistered aircraftBuilt 1980 · S/N E-1745 N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653 N362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N LJ760 N362PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeBuilt 1976 · S/N 017 N362PTN378c LLC · Parker, COS/N 73 N362RMAmerican Aviation Inc · Brooksville, FLBuilt 1984 · S/N E-2194 N362SAScapha Air LLC · Boone, NCS/N E-3517 N362SBNilco Enterprises Inc · Irving, TXBuilt 1981 · S/N E-1848 N362TWInjury Care Center LLC · Alpharetta, GABuilt 1983 · S/N 650-0011 N363Tolen Dave · Gallatin, MOS/N D-252 N3636AScull Adam C · Hockessin, DEBuilt 1978 · S/N E-1399 N363BSMjti LLC · Santa Rosa, CABuilt 2017 · S/N 525-0961 N363DFreeman Holdings Of West Texas LLC · Medford, ORBuilt 1995 · S/N BB-1503 N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799 N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000 N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143 N363MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N FL-1078 N363RMankind Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E-97 N36444United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31643 N36447United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31650 N36469United Airlines Inc · Chicago, ILBuilt 2013 · S/N 36600 N36472United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31653 N36476United Airlines Inc · Chicago, ILBuilt 2013 · S/N 38703 N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148 N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240

Back to AD 2006-16-18 R1