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.

N774DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1992 · S/N 208B0324 N774FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0271 N774JTRegistration Pending · Springfield, MORegistration pendingBuilt 2020 · S/N 525-1065 N774KVTjr Aviation LLC · Allentown, PABuilt 1982 · S/N 31T-8166057 N774MBVida Trade And Management Group · Charlotte, NCS/N 339 N774SBAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 560-0684 N774SPSamaritans Purse · Boone, NCBuilt 2013 · S/N 208B5030 N77510United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32828 N77518United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31605 N77520United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31658 N77525United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31659 N77530United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39998 N77535United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62751 N77536United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62766 N77537United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62767 N77538United Airlines Inc · Chicago, ILBuilt 2016 · S/N 63694 N77539United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63642 N77542United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63647 N7758RT & C Aviation LLC · Ardmore, OKBuilt 1968 · S/N E-112 N775DMGeneration Jets LLC · Denison, TXBuilt 1978 · S/N LJ-764 N775FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0272 N775KH75 Express Inc · Mooresville, NCBuilt 2020 · S/N 208B5593 N775MGPapa Romeo LLC · Hattiesburg, MSBuilt 2007 · S/N FL-553 N775SCZw Air LLC · Little Rock, ARBuilt 1981 · S/N BB-808 N775SMBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N FL-1057 N775TBCj Partners LLC · Springfield, ILBuilt 1994 · S/N 525-0075 N7760RJenkins Seth · Charlotte, NCBuilt 1968 · S/N E-114 N7767International Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N FL-672 N776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697 N776GMGlobus Aviation LLC · Audubon, PAFirst renewal noticeS/N 650-0124 N776RWReliance Well Service Inc · Magnolia, ARBuilt 2006 · S/N BB-1926 N776TFStanking Holdings LLC · Wayzata, MNBuilt 2008 · S/N 20800500 N776WCWingtip Corporation · Valparaiso, INS/N TH-570 N776WRTwin Eagles Aviation Inc · Fort Mohave, AZBuilt 1998 · S/N 560-0459 N776YDRapp Larry · Elbow Lake, MNBuilt 1988 · S/N E-2463 N7779VAircraft Fidelity Corp Trustee · Dover, DEBuilt 2001 · S/N BB-1770 N777AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-899 N777AQBcms Investments LLC · Dexter, MOBuilt 1979 · S/N BB-583 N777AWFair Air Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N BB-536 N777AXJc Investors Group LLC · Coral Springs, FLBuilt 1988 · S/N S5500149 N777BLBlackstone Mm Assets LLC · Beverly Hills, CABuilt 1990 · S/N 048 N777BPFloss Five Ten LLC · Lewisville, NCBuilt 2018 · S/N 525-0986 N777CJHarvest International Ministries Inc · Texarkana, ARBuilt 1986 · S/N 650-0122 N777EB7eb Aviation LLC · Dallas, TXBuilt 1979 · S/N LJ-863 N777EHMilligan Michael Zachery · Reno, NVFirst renewal noticeS/N 257020 N777EVSelldorff John · Chatham, MABuilt 1990 · S/N E-2520 N777FCAlghazzawi Hani · Holland, OHBuilt 1986 · S/N 508 N777FEUnlimited Boat Sales Inc · Page, AZS/N RJ-30 N777HGProcyon Group Inc · Wilmington, DEBuilt 1975 · S/N E-777 N777JCPrimiani Maurizio · Great Falls, MTS/N D-685

Back to AD 2006-16-18 R1