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

N55BAKarma55ba LLC · Stuart, FLS/N 258356N55BHTop Flight LLC · Gilbert, WVBuilt 1984 · S/N 650-0041N55CJN55cj LLC · Modesto, CABuilt 1998 · S/N 525-0298N55EAShamrock Aviation LLC · Greensboro, NCBuilt 1990 · S/N 560-0055N55FGWestwind Air LLC · Canton, GABuilt 1979 · S/N 267N55FJN55fj LLC · El Cajon, CABuilt 1983 · S/N 089N55HCMile High Club Of Texas LLC · El Paso, TXBuilt 1975 · S/N LW-134N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276N55JPDakota Aircraft Inc · Pierre, SDBuilt 1998 · S/N 525-0296N55KMbi · Indn Hbr Bch, FLBuilt 1979 · S/N E-1601N55LBPie High LLC · Atlanta, GABuilt 2000 · S/N 258494N55MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 1981 · S/N LJ-974N55MWCitation 560 LLC · Oshkosh, WIBuilt 2005 · S/N 560-0688N55PCCteh Leasing LLC · N Little Rock, ARBuilt 1983 · S/N BB-1170N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071N55SKSierrakilo LLC Trustee · Fort Lauderdale, FLBuilt 1994 · S/N 525-0063N55SRGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N BB-445N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901N55VHCombined Aircraft Ownership LLC · Fargo, NDBuilt 2022 · S/N 525-1120N55WFIcm Inc · Colwich, KSBuilt 1985 · S/N LJ-1114N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073N55XPAtlas Leasing Partners LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258583N55ZREuroaviaition Inc Trustee · KematenBuilt 1999 · S/N LJ-1566N56Textron Aviation Inc · Wichita, KSS/N FL-1390N560AFMegashipp Ventures II LLC · The Woodlands, TXBuilt 1990 · S/N 560-0100N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179N560AVTeton Leasing LLC · Pocatello, IDBuilt 1995 · S/N 560-0321N560BCPlatform Energy Aviation LLC · Lubbock, TXBuilt 1990 · S/N 560-0032N560BJBanu LLC · Las Vegas, NVBuilt 1990 · S/N 560-0058N560BLKac Md LLC · Fort Mill, SCBuilt 2002 · S/N 560-0633N560BMBruce Tanski Construction & Development LLC · Halfmoon, NYBuilt 2004 · S/N 560-0668N560BPCitation V Partners LLC · Las Vegas, NVBuilt 1992 · S/N 560-0172N560CJettech Holdings LLC · Broomfield, COBuilt 1998 · S/N 560-0461N560CBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2004 · S/N 560-0655N560CCJet Centennial LLC · Greenwood Village, COS/N 560-0064N560CE5 Star Aviation LLC · Aurora, MOBuilt 2001 · S/N 560-0555N560CFMax Air Group LLC · Waterford, MIBuilt 1990 · S/N 560-0040N560CJTrans Exec Air Service Inc · Van Nuys, CABuilt 1990 · S/N 5600086N560CSPlatinum Faith LLC · Middletown, DEBuilt 2001 · S/N 560-0549N560CVHw Aviation LLC · Katy, TXBuilt 1989 · S/N 560-0038N560CXSpudaire LLC · Pasco, WABuilt 2001 · S/N 560-0582N560CZRosado Aviation Inc · Moosic, PABuilt 1989 · S/N 560-0002N560DLLandmark Media Enterprises LLC · Norfolk, VAS/N 560-0761N560EMEjb LLC · Ponce Inlet, FLBuilt 1992 · S/N 5600201N560EPZero Five Kilo Corporate · Jackson, WYBuilt 2008 · S/N 560-0794N560FFParrott Air LLC · Florence, SCBuilt 1998 · S/N 560-0477N560FPEdwards Carl E Jr Trustee · Oklahoma City, OKBuilt 2001 · S/N 560-0566N560FTN560ft LLC · Middletown, DEBuilt 1990 · S/N 5600042N560FWPspb Aviation LLC · Fort Worth, TXBuilt 1991 · S/N 560-0123N560GMachugh David · Pasco, WABuilt 1991 · S/N 560-0112
Back to AD 2006-16-18 R1