OpenAirDocs.org
AD 2006-01-11 R1

Registered aircraft · 1,016

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-01-11-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-01-11-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.

N77JJCc99 LLC · Wilmington, DEBuilt 2025 · S/N 208B5912N77NFNate Holyoke Builders Inc · Holden, MEBuilt 2004 · S/N 20800382N77RZRieger Joseph M · Ashland, ORBuilt 2009 · S/N 20800512N780FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0277N781FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0278N782FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0280N783FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0281N784FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0282N785FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0283N785WWAce Aviation LLC · Phoenix, AZBuilt 1999 · S/N 208B0792N786FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0284N786WWWestwind Aviation Inc · Phoenix, AZBuilt 2004 · S/N 208B1099N787FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0285N787RAHorizon Management LLC · San Juan, PRBuilt 2016 · S/N 208B5335N788FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0286N789AHApple Realty Group Inc · Richmond, VABuilt 2016 · S/N 208B5281N789FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0287N78SAMartinaire Aviation LLC · Addison, TXBuilt 1995 · S/N 208B0467N790FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0288N792FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0290N794FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0292N795FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0293N795JGrant Aviation Inc · Anchorage, AKBuilt 2019 · S/N 208B5550N796FEAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0212N798FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0174N801FLDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2000 · S/N 208B-0809N801JASpokane Turbine Skydiving LLC · Medical Lake, WABuilt 1985 · S/N 20800009N801TWJk Aircraft Options LLC · Aripeka, FLBuilt 1999 · S/N 20800297N801VWN776va LLC · Wainscott, NYBuilt 2008 · S/N 20800503N802AAMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0873N803FN803f Inc · Addison, TXBuilt 2005 · S/N 208B-1112N803JACaravan Flight Services LLC · Bayside, NYBuilt 1985 · S/N 20800016N804FEFederal Express Corporation · Memphis, TNS/N 208B0039N804THPa1 208b-0421 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0421N805DZSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1990 · S/N 20800174N805ELKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 208B0998N805THAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0609N806JASomething Aviation LLC · Dekalb, ILBuilt 1985 · S/N 20800072N807EVRegistered aircraftS/N 208B0807N807FERegistration Pending · Mountain View, CARegistration pendingBuilt 1987 · S/N 208B0041N807JAAv Serv LLC · Dover, DEBuilt 1985 · S/N 20800075N808MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2427N809SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 20800081N809SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 208B5725N80GEWin Win Aviation Inc · Wake Forest, NCBuilt 1996 · S/N 208B0585N80JFIsr Aviation LLC · Wilmington, DEBuilt 1993 · S/N 208B0352N80KLLiberty Leasing Vii LLC · Melbourne, FLBuilt 2007 · S/N 20800411N80RDRobert Wiplinger LLC · Inver Grove, MNBuilt 1986 · S/N 20800085N811LSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 208B2212N814GVIsr Aviation LLC · Wilmington, DEBuilt 2002 · S/N 208B0958
Back to AD 2006-01-11 R1