OpenAirDocs.org
AD 2008-07-11 R1

Registered aircraft · 545

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:2008-07-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:2008-07-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.

N7ZTZia Air LLC · Redwood City, CABuilt 2001 · S/N 385N801JLittle Family Farms Lllp · Kenmore, WABuilt 2007 · S/N 801N802HSSecurity Holdings LLC · Richmond, VABuilt 1995 · S/N 118N805JAEmpireair LLC · Spokane Valley, WABuilt 2007 · S/N 805N807DAero Tomasso LLC · San Ramon, CABuilt 2007 · S/N 807N810VJVee Jay Equipment (De) LLC · Clarkston, MIBuilt 2005 · S/N 610N811PCBroadway Swiss Air LLC · Huntsville, ALBuilt 2007 · S/N 811N811VMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N 316N812PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 106N814PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 110N814WABoutique Air Inc · Dallas, TXBuilt 2007 · S/N 814N817WAWarner Alan/N-Leasing LLC · Fort Worth, TXBuilt 1996 · S/N 137N818RAWanderlust Air LLC · Fort Lauderdale, FLBuilt 1997 · S/N 179N821CTAxiom Aviation Group LLC · Webb City, MOBuilt 2006 · S/N 713N822DADuncan Aviation Inc · Lincoln, NEBuilt 2008 · S/N 878N824SMKlsw Ventures LLC · Corpus Christi, TXBuilt 2007 · S/N 824N825MKSouthern Palms Leasing LLC · Sarasota, FLBuilt 2007 · S/N 839N828RXN828rx Inc Trustee · Wilmington, DEBuilt 2003 · S/N 531N828VVRegistered aircraftBuilt 2007 · S/N 826N831JYJoby Aero Inc · Santa Cruz, CAS/N 876N832BHVahalda LLC · Bend, ORBuilt 2003 · S/N 508N8421ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 430N842WFEmpireair LLC · Spokane Valley, WAS/N 842N846PWU-Haul Co Of Oregon · Phoenix, AZBuilt 2007 · S/N 846N84GEHighwings LLC · Fargo, NDBuilt 2001 · S/N 408N850CBUS Air Force Special Operations Command/A5km · Hurlburt Field, FLBuilt 2007 · S/N 850N851EBBridger Aviation Services LLC · Belgrade, MTS/N 851N851RMLas Madronas Aviation LLC · Incline Village, NVS/N 360N852ALMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 213N852FRMcha Holdings LLC · New York, NYBuilt 2007 · S/N 852N853ALMetro Aviation Inc · Shreveport, LABuilt 1996 · S/N 168N853WMK2 Leasing LLC · Sanford, NCBuilt 2007 · S/N 853N854ALAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 397N859PLH2o Aviation LLC · Fort Myers, FLBuilt 2007 · S/N 859N861PPIrlbeckbruch Plane LLC · York, NEBuilt 2003 · S/N 510N863CBThomas Pride Lp · Ogden, UTBuilt 2007 · S/N 862N866KMMac Aviation LLC · Fargo, NDBuilt 2003 · S/N 528N867PPPrime Air LLC · Charlotte, NCBuilt 2007 · S/N 867N868PEIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2007 · S/N 868N870CBRaci Management Company Inc · Ogden, UTBuilt 2005 · S/N 657N870KCN870kc LLC · Richland, NEBuilt 2007 · S/N 870N873PCJacksons Food Stores Inc · Boise, IDBuilt 2007 · S/N 873N874EBSpur Aviation Services Lc · Twin Falls, IDBuilt 2008 · S/N 874N875RJUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 646N879EBBridger Aerospace Group LLC · Belgrade, MTBuilt 2008 · S/N 879N87CBClayton Boyd Agricultural Equipment LLC · Valley View, TXBuilt 2005 · S/N 681N880DCMount Rich LLC · Palmer, AKBuilt 2006 · S/N 726N881TWHinterland Holdings LLC · Anchorage, AKBuilt 2007 · S/N 806N888GWSouthland Sod Farms Operations Inc · Oxnard, CABuilt 2001 · S/N 421N888NTNbt Air LLC · Baton Rouge, LABuilt 1999 · S/N 285
Back to AD 2008-07-11 R1