OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N977BHMotors Inc · Cumming, GAS/N 421C0227N977CTPrecision Aerial Photography LLC · Oceanside, CABuilt 1993 · S/N E-2791N977DMDfm III LLC · Cortland, NYBuilt 1998 · S/N 560-0494N977DTTomlin Don E · Midland, TXBuilt 2008 · S/N 560-0781N977FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0104N977GFBrown Bear Aircraft LLC · Hartland, MEBuilt 1972 · S/N TH-175N977MRN977mr LLC · Pagosa Springs, COBuilt 2002 · S/N 560-0623N977NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31225N97826Atel Leasing Corp Trustee · San Francisco, CABuilt 2006 · S/N 208B1223N978ANMsn 30100 Trust · Wilmington, DEBuilt 2001 · S/N 30100N978GKFox Whiskey Inc · Wilmington, DEBuilt 1996 · S/N E-3047N978MAN978ma LLC · Eaton, COBuilt 2005 · S/N 560-0683N978NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31226N978TSWaxhaw Flyers LLC · Rosedale, MSBuilt 1997 · S/N FL-171N979ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 29568N979DKCatia Resources LLC · Garden City, TXBuilt 1985 · S/N FA-79N979FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0228N979MAMeisner Aircraft Inc · Burlington, WIBuilt 1978 · S/N E-1294N979NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31228N979PWFlight By Pwi LLC · Nappanee, INBuilt 2004 · S/N 560-0650N979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N TH-1932N979SVSkydive Guam Inc · Barrigada, GUBuilt 2002 · S/N 208B-0979N979TX11 Niner Aviation LLC · Wilmington, DEBuilt 2017 · S/N 525-0979N97ALWbj Aviation LLC · Jackson, GABuilt 1988 · S/N 650-0155N97BHTs72 Management LLC · Wilson, WYS/N 560-0290N97BKA&D Machinery LLC · Hartsville, SCBuilt 1996 · S/N E-3064N97CLC2 Beach St Holdings II LLC · Ormond Beach, FLBuilt 1992 · S/N 560-0173N97DHEmbry Aero Ltd · Greenville, ILBuilt 1978 · S/N 421C0450N97EBHendee Edd C · Houston, TXBuilt 1986 · S/N FA-97N97GWLeft Coast Transport LLC · Largo, FLBuilt 1977 · S/N E-1143N97HAWright Air Service Inc · Fairbanks, AKBuilt 1997 · S/N 208B0610N97HMEd Santos & Associates LLC Trustee · Wilmington, DES/N LA44N97JABelt Tech Aero LLC · Washington, INBuilt 2022 · S/N 525-1113N97QRQrp Air LLC · Quincy, ILBuilt 2023 · S/N FL-1313N97RSSchiffenhaus Robert · EspooBuilt 1984 · S/N TH-1414N97SKL & L Aviation LLC · Bossier City, LABuilt 1998 · S/N 525-0290N97SZSierra Zulu Aircraft Management LLC · Wilmington, DEBuilt 1983 · S/N BB1166N97VFLynnco Airways LLC · Cleveland, TNBuilt 1996 · S/N 525-0171N97WCHf Air LLC · Hattisburg, MSBuilt 1990 · S/N BB-1382N97WELawrence Aviation Inc · Austin, TXBuilt 1997 · S/N BB-1586N97WSPrestige Worldwide Enterprises LLC · Germantown, TNBuilt 1979 · S/N E-1433N97XPE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1996 · S/N 258310N97XXTaylor 483 LLC · Albuquerque, NMBuilt 2020 · S/N 208B5577N980ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33203N980BCJet Rider LLC · Wilmington, DEBuilt 2000 · S/N FL-283N980CROcr Aviation · Long Beach, CAFirst renewal noticeBuilt 1979 · S/N LA-23N980FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0108N980FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0489N980NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31229N980PADesantis Anthony · Memphis, TNS/N TH-1980
Back to AD 2006-16-18 R1