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.

N168RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800158N168UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0863N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399N169BADesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1967 · S/N 103N169CRContinental Resources Inc · Baker, MTBuilt 2026 · S/N 560-6506N169DRLegacy Aviation LLC · Tea, SDBuilt 1989 · S/N LJ-1205N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169N169PHunter James F · Sevierville, TNBuilt 1947 · S/N D-815N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030N169TGNordic Sun LLC · Garner, NCBuilt 2005 · S/N E-3627N169UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0864N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16EJAlphaalpha Aviation LLC · Paragould, ARS/N E-3507N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647N16KWWild Blue Aviation LLC · Wilmington, DEBuilt 1996 · S/N LJ-1435N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16NLWh Air LLC · Clearwater, FLBuilt 1977 · S/N 501-0043N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N16QCDawson Aircraft Inc · Clinton, ARS/N 421C0689N16RPRose Aviation LLC · Sarasota, FLBuilt 1985 · S/N S5500047N16TMTriad Physician Resources Inc · Longview, TXBuilt 1998 · S/N LJ-1507N16TSCypress Aircraft Sales LLC · Clemont, FLS/N 550-0030N16VGRegistered aircraftBuilt 1980 · S/N 501-0157N16WBPacebook Aviation LLC · Albany, GABuilt 2016 · S/N 525-0905N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N170MUCitationjet 525 LLC · Wilmington, DEFirst renewal noticeBuilt 1996 · S/N 525-0170N170SEGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1708N170UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0865N1714HBlue Flight II LLC · Miami, FLBuilt 2025 · S/N 208B5861N1717RJaaack Air LLC · Henderson, NVBuilt 1983 · S/N 501-0251N171CEGarrison Randy · Queen City, TXBuilt 1973 · S/N E-504N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71N171DDNorfolk Aircraft Interiors LLC · Virginia Beach, VAS/N E-108N171GCRigidworks LLC · Anaconda, MTBuilt 1974 · S/N 406N171MDN171md LLC · Amarillo, TXBuilt 1993 · S/N 258251N171MSStick Ball Rudder LLC · Bonita Springs, FLBuilt 2002 · S/N LJ-1668N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992N171UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24322N171UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0866N171WJN501sp LLC · Mount Airy, MDBuilt 1981 · S/N 501-0171
Back to AD 2006-16-18 R1