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.

N560ZSCape Romain Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 1994 · S/N 560-0281N561BCInternational Bank Of Commerce · Laredo, TXBuilt 1998 · S/N 525-0257N561CCAir Land Leasing LLC · Madera, CABuilt 1997 · S/N 560-0416N561CFTitan Air LLC · Pasco, WAS/N 560-0003N561CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1991 · S/N 560-0099N561DAPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N 5600314N561FPZulu Romeo LLC · Ontario, ORBuilt 2001 · S/N 560-0561N561JSDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 5600413N561KGGehrair LLC · Palm Beach Gardens, FLBuilt 1991 · S/N FA-212N561MTN561mt LLC · Clovis, NMBuilt 1991 · S/N 560-0122N561PAJmrkfly LLC · Naples, FLS/N 560-0116N561PFN561pf LLC · Richland, WABuilt 1990 · S/N 560-0048N561PSTlc Aviation LLC · Bloomfield Hills, MIBuilt 1980 · S/N NA-0262N561SRChrysler Aviation Inc · Van Nuys, CABuilt 1991 · S/N 560-0138N561SSEnvision Ventures LLC · Williston, NDBuilt 1979 · S/N BB-464N561WFDm Air LLC · Pasco, WABuilt 1992 · S/N 560-0182N561ZAZulu Air LLC · Opa Locka, FLS/N BB1180N5626YHillcrest Air LLC · Jackson, TNBuilt 1991 · S/N FL-43N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091N562CLGrandview Air LLC · Eldridge, IAS/N 560-0768N562CPVantage Air Corp · Kalispell, MTBuilt 1977 · S/N 562N562DTriton Air Solutions LLC · Fenton, MIS/N E-3577N562PCDelta Farm Express LLC · Richview, ILBuilt 1996 · S/N 525-0151N562YDion William · Coupeville, WABuilt 1991 · S/N E-2633N5634QLegacy Aero LLC · Jonesboro, ARBuilt 1990 · S/N TH-1598N5636GTres Locos Gringos LLC · Lubbock, TXBuilt 1990 · S/N TH-1586N5639ZHowman Aero LLC · Cleveland, OHBuilt 1990 · S/N E-2535N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180N563DDTextron Aviation Inc · Wichita, KSS/N 525-1428N563MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0550N563TMAlamance Aviation LLC · Wilmington, DEBuilt 1991 · S/N 5600124N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296N5641XBuche-Air LLC · Sioux Falls, SDBuilt 1990 · S/N LJ-1241N5643CAdvance LLC · Waterville, MES/N TH-1573N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103N564BRKaleidoscope Charter Services Corp · Kansas City, MOS/N NA0287N564MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0569N564SWFreight Runners Express Inc · Milwaukee, WIBuilt 1998 · S/N 120339N564TBK3hw LLC · Pattison, TXBuilt 1991 · S/N 560-0141N564TJBranch Aircraft Leasing Inc · Ocala, FLBuilt 1997 · S/N 560-0432N56539Six 27 Properties LLC · Flint, TXBuilt 1990 · S/N E2539N5655KYellow Airplane LLC · Columbus, NEBuilt 1990 · S/N FL-12N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181N565KEAviation Company Inc · Cheyenne, WYBuilt 1987 · S/N 17N565KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 650-0131N565MJse Aviation LLC · Franklin, NHBuilt 1990 · S/N E-2525N565PAero Cruz LLC · Agoura Hills, CABuilt 1999 · S/N E-3280N565SKM&N Equipment LLC · Englewood, COBuilt 2002 · S/N 258604N565TTWright Tony Lee · Douglas, GABuilt 1989 · S/N 560-0023N566ALKgjc Aero LLC · Dow City, IABuilt 1995 · S/N LJ-1415
Back to AD 2006-16-18 R1