OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,794

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
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.

N113MPBan Air LLC · Boerne, TXBuilt 1982 · S/N 421C1235N113RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0654N113USUnited Supermarkets LLC · Lubbock, TXBuilt 2006 · S/N 560-0701N11421Beach Prairie LLC · Cedar Rapids, IABuilt 2001 · S/N E-3378N114CWMatagorda Production Co · Houston, TXBuilt 1980 · S/N LA97N114HBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1533N114KNKnc Flights LLC · Beaverton, ORBuilt 1998 · S/N 560-0463N114PCHeller Andrew R · Austin, TXBuilt 1975 · S/N TH-661N114PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2021N114RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0677N1154FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 208B1065N1157TSalloom Mary M · Gaithersburg, MDBuilt 1975 · S/N E-640N115CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0011N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669N115GKCommuter Redux LLC · Oxford, CTBuilt 2020 · S/N 208B5590N115PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2048N115PJFloatsix Leasing LLC · Wilmington, DEBuilt 2017 · S/N 208B5361N115TTNo Delay LLC · Tickfaw, LABuilt 1992 · S/N FL-74N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052N1167ADakota Wings Of Delaware LLC · Sioux Falls, SDBuilt 2018 · S/N FL-1167N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081N116MLRegistration Pending · Coshocton, OHRegistration pendingBuilt 2017 · S/N 525-0952N116TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N FL-78N116TXPlacid Air LLC · Naples, FLBuilt 1999 · S/N BB-1685N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433N117ECRambana & Ricci Pllc · Tallahassee, FLBuilt 1977 · S/N E-1118N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205N117MAT&J Aviation LLC · Clovis, NMBuilt 1979 · S/N 501-0249N117MFJet Sales Of Stuart LLC · Stuart, FLBuilt 1978 · S/N LJ-779N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17N1184JD&D Chessies LLC · Wilmington, DEBuilt 1980 · S/N E1690N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212N118CFChaudoin Stephen G Trustee · Raymond, NHBuilt 1978 · S/N TH-924N118DLN118dl LLC · Dover, DEBuilt 2003 · S/N 258607N118JKRegistered aircraftBuilt 1984 · S/N 445N118KN118k LLC · Littleton, COBuilt 1984 · S/N 501-0686N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111
Back to AD 2006-16-18 R1