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.

N5822WKanza Aviation LLC · Andover, KSBuilt 1971 · S/N TH167N582TMArnst Jodi M · Clio, MIBuilt 1974 · S/N E-582N5831RBroome Adam H · Chapel Hill, NCBuilt 1983 · S/N E-2096N583ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35681N583CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1291N583JHBrykin Leasing Corp · Celina, TXBuilt 2002 · S/N 208B1001N583SDMiller Waste Mills Inc · Winona, MNBuilt 1993 · S/N 650-7034N583TL518mv Air LLC · Modesto, CABuilt 2001 · S/N 560-0583N583WCWatkins Construction Company LLC · Corsicana, TXBuilt 2011 · S/N FL-785N5844YLindsey Charles A · Madison, GABuilt 1980 · S/N TH-1148N584ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35682N584BLSale Reported · Greeley, COSale reportedBuilt 1974 · S/N TH-446N584CKKalitta Charters LLC · Ypsilanti, MIBuilt 1973 · S/N TH-319N584CLKetcham Francis A · Sausalito, CAS/N TH-1034N584DFHangar 3 LLC · Milledgeville, GABuilt 1990 · S/N TH-1605N584DGN584dg LLC · Nashua, NHBuilt 1979 · S/N TH-1042N584DTTiger Flight LLC · Florence, SCBuilt 1995 · S/N TH-1745N584HPN305yv LLC · Doral, FLBuilt 1983 · S/N TH-1365N584JTGoff James T · Sunriver, ORBuilt 1980 · S/N TH-1127N584METwo Spinny Things LLC · Overland Park, KSBuilt 1974 · S/N TH-427N584MJC5 Aviation LLC · Harrison, ARBuilt 1987 · S/N TH-1512N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615N584RCrooked Creek Enterprises LLC · Nacogdoches, TXBuilt 1985 · S/N TH-1464N584SMRegistered aircraftBuilt 1973 · S/N TH-412N584TBSundancer Enterprises LLC · Norman, OKBuilt 1997 · S/N TH-1810N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699N58501Pinellas County Sheriffs Office · Largo, FLBuilt 1999 · S/N 208B0778N585ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35683N585ATJr & M Air LLC · San Antonio, TXBuilt 1989 · S/N LJ-1203N585BGGuardian Aero LLC · Wilmington, DES/N 501-0185N585CEAugusta Aviation Inc · Hilton Head Island, SCS/N BB1194N585CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1299N585FDWoodbine Aviation LLC · Lewes, DEBuilt 1992 · S/N 560-0113N585KGWhitgo LLC · Lucas, TXS/N E-3413N585MCStuart Nathan · Saint Augustine, FLS/N 525-0452N585MJCostanzo Aviation Inc · Bethany Beach, DEBuilt 1977 · S/N E-1195N585MLBh Transportation LLC · Jackson, TNBuilt 2000 · S/N 525-0402N585RBPonderosa Aviation LLC · Safford, AZBuilt 1979 · S/N BB-528N585RJMr Aeronautics LLC · Clarksville, TNBuilt 1985 · S/N TH-1479N585SASpirit Air Inc · Salmon, IDS/N 208B5032N585SCBombom LLC · Knoxville, TNBuilt 2008 · S/N FL-584N585VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258585N586ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35189N586BWRegistered aircraftBuilt 2005 · S/N FL-432N586CKKalitta Charters LLC · Ypsilanti, MIS/N TH-1084N586UCMegel Air LLC · Cleveland, GABuilt 1983 · S/N BB-1118N586YDDodson International Parts Inc · Rantoul, KSS/N LJ1696N5871Sparrow Group LLC · Belton, TXS/N 20800135N587ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH1530N587ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35684
Back to AD 2006-16-18 R1