OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,280

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-06-28-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-06-28-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.

N24MWMn Aviation LLC · Dayton, OHBuilt 2011 · S/N 3758N24PTN24pt LLC · Winter Park, FLBuilt 1977 · S/N 4410015N24PYMl Aero Inc Trustee · Wilmington, DEBuilt 2007 · S/N 42568N24RFAlatenn Construction & Properties LLC · Winchester, TNBuilt 2004 · S/N 1168N24TSAirquest Aviation Lp · Butler, PABuilt 1979 · S/N 28-7916462N24VRHarris Daniel P · Auburn, ALBuilt 1981 · S/N 32R-8229006N24WEPake Flying Services LLC · Felton, MNBuilt 1998 · S/N 3449071N24XTAircraft Resource Center Inc · Lakeville, MNBuilt 2000 · S/N 1039N2500TJ & C Holdings Inc · Laguna Beach, CABuilt 2004 · S/N 41026N2502QMaxim Aviation LLC · Sugarloaf Key, FLBuilt 2005 · S/N 42076N25030Eller Walton G III · Katy, TXBuilt 1985 · S/N 28-8590081N2504TColumbia N2504t LLC · North Easton, MABuilt 2006 · S/N 41575N2505JHarrah Enterprises LLC · Cornelius, NCBuilt 2006 · S/N 41576N2506VLancestrom LLC · Tomball, TXS/N 42067N2507LSimply Southern N2507l LLC · Fayetteville, GABuilt 2005 · S/N 41106N2507SFriedman Jeffrey C Trustee · Oakland, CAS/N 41567N2509WDouble D'S LLC · Massillon, OHBuilt 2005 · S/N 41061N250BTHeart Gate Enterprises LLC · Pittsburgh, PABuilt 2002 · S/N 4636334N250CBMaitland Scott · Chapel Hill, NCBuilt 2002 · S/N 40.236N250CDValiair Ltd Co Trustee · Casper, WYS/N 1146N250CKCirrus Sr22 3421 Inc Owner Trustee · Wilmington, DEBuilt 2009 · S/N 3421N250DFDmfs Leasing LLC · Des Moines, IABuilt 2026 · S/N 4636878N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100N250GKCirrus Design Corp · Duluth, MNS/N 11735N250JHJh Diaries LLC · Dublin, OHBuilt 2013 · S/N 3993N250PMN250pm LLC · Knoxville, TNBuilt 2014 · S/N 4692204N250SAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 46-97004N250SMRkm Aviation LLC · Lexington, NCBuilt 2012 · S/N 2178N250SXHigh Clouds 22 LLC · Montgomery, TXS/N 3632N250TMAbd Equipment LLC · Aledo, TXS/N BB822N250WFGita Aviation LLC · Dallas, TXBuilt 1978 · S/N 28-7916088N2510YMiller Aviation LLC · Sedona, AZS/N 41572N2511GVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41101N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063N2511YPrieur Philip · Suwanee, GABuilt 2005 · S/N 41060N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077N2514FVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41093N2515BIndependent Columbia Aviators LLC · Katonah, NYBuilt 2004 · S/N 41040N2515QHackney Joel · Trabuco Canyon, CABuilt 2006 · S/N 41585N2515USummit Professional Business Services LLC · Grand Haven, MIBuilt 1979 · S/N 28-8016026N2515YNationwide Aviation LLC · Weatherford, TXBuilt 1985 · S/N 28-8516074N2516SCol4 Training LLC · Wichita, KSBuilt 2006 · S/N 41570N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081N2518HHakan Michael · Carpinteria, CABuilt 2005 · S/N 41079N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027N2519FAmerican Aviation Inc · Brooksville, FLBuilt 2012 · S/N 4697494N251ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496047N251CPBurshtan David H · Huntington Beach, CABuilt 2008 · S/N 3176N251CTFly Like Snoopie Aviation LLC · Manahattan Beach, CABuilt 2026 · S/N 11215N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426
Back to AD 2008-06-28 R1