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.

N731FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0480 N731JAMccallister Aviation Rentals & Sales LLC · Qulin, MOBuilt 1998 · S/N TH-1884 N731JPParker Aviation LLC · West Chicago, ILS/N TH-2064 N731LCSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1137 N731PCapital Dental Management · Medford, ORBuilt 2001 · S/N TH-1997 N731PBBeaver Creek Aviation LLC · Perry, IABuilt 1980 · S/N 31T8166001 N731SGIsgrowth Machine LLC · Mankato, MNS/N FL-503 N731TRSapphire Living Inc · West Linn, ORBuilt 1997 · S/N 560-0411 N731WCCross Wayne Trustee · Novato, CABuilt 2001 · S/N E-3404 N73251United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30582 N73256United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30611 N73259United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30803 N73270United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31632 N73275United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31593 N73276United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31594 N73278United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31596 N73283Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31606 N73291Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 33454 N73299United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34005 N732AADjcj LLC · Nashville, TNBuilt 1993 · S/N 258243 N732CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1989 · S/N 24271 N732FDFederal Express Corporation · Memphis, TNBuilt 1993 · S/N 713 N732LCSchuman Carriage Co Ltd · Honolulu, HIBuilt 2005 · S/N 208B1149 N732MTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 525-0685 N732MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 208B1083 N732P626cf LLC · Lynchburg, VABuilt 1999 · S/N TH-1929 N73380Bank Of Utah Trustee · Salt Lake City, UTS/N FL480 N7339RDoell Tom C · Dallas, TXBuilt 1974 · S/N E-563 N733CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1992 · S/N 25849 N733FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 715 N733GBuzick Air LLC · Bardstown, KYBuilt 2004 · S/N 340 N73406United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30123 N73445United Airlines Inc · Chicago, ILBuilt 2011 · S/N 40000 N7346RSeagull Flying Club Inc · San Jose, CABuilt 1974 · S/N E-569 N7347RN145ta LLC · Carson City, NVBuilt 1974 · S/N TH-482 N734CBGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1508 N734CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1993 · S/N 25858 N734DBN779at LLC · Punta Gorda, FLS/N 560-0143 N7352CCsds Asset Management LLC · Rllng Hls Est, CAS/N 26340 N7353CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27634 N7354CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27425 N7357RWalter Charles T Jr · Ocala, FLBuilt 1974 · S/N E-571 N7358BHinkle Aviation LLC · Moro, ARS/N TH-373 N735CAMetrea Special Aerospace Isr Inc · Oklahoma City, OKBuilt 2002 · S/N FL-348 N735EDynamic Aviation Group Inc · Bridgewater, VAS/N 26339 N735PTwo J Aviation LLC · Lima, OHBuilt 1978 · S/N TH-981 N735TDynamic Avlease Inc · Bridgewater, VABuilt 1990 · S/N 24651 N736WDCassil Robert B Trustee · San Francisco, CABuilt 2005 · S/N 20800392 N7379RSunny Skies Inc · Columbus, GABuilt 1974 · S/N TH-512 N737MMMadrock LLC · Dallas, TXBuilt 2000 · S/N 650-7113

Back to AD 2006-16-18 R1