OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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:2018-07-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-13')
  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.

N2QAir Sansone LLC · Wilmington, DEBuilt 2005 · S/N 680-0051N2QGFlagship Private Air LLC · Jackson, MIBuilt 2008 · S/N 680-0231N2WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 510-0459N300HLCx4people Inc · Irvine, CABuilt 2009 · S/N 680-0286N300JCRegistered aircraftBuilt 2021 · S/N 680-0597N300VRLm Aerospace Corp · Aventura, FLBuilt 2007 · S/N 510-0044N301AJCrawford Products Co Inc · Huntington Beach, CABuilt 2009 · S/N 510-0233N303TPPti Air LLC · Tulsa, OKBuilt 2008 · S/N 680-0203N304LHS&R Transportation II LLC · Wilmington, NCBuilt 2022 · S/N 680A0304N307LSCombined Aircraft Ownership LLC · Fargo, NDS/N 680-0066N308LJNspiration Aviation LLC · Menlo Park, CABuilt 2006 · S/N 680-0109N308QSRegistered aircraftBuilt 2006 · S/N 680-0116N3099Bank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2010 · S/N 680-0306N30GNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 680-0570N310BNBcwings LLC · Hartland, WIBuilt 2013 · S/N 6800516N311VULatitude 4 LLC · Dover, DEBuilt 2015 · S/N 680A0022N313AQAdjacent Air LLC · Holdrege, NEBuilt 2017 · S/N 510-0479N313FHHertrich Aviation LLC · Seaford, DEBuilt 2016 · S/N 680A0023N313QSRegistered aircraftBuilt 2007 · S/N 680-0140N315QSRegistered aircraftBuilt 2008 · S/N 680-0220N317QSRegistered aircraftBuilt 2007 · S/N 680-0160N318SMKingston Ventures II LLC · Missoula, MTBuilt 2016 · S/N 680A-0036N320HBHb Equipment Co LLC · Wildwood, FLBuilt 2008 · S/N 680-0188N320QSRegistered aircraftBuilt 2007 · S/N 680-0169N322CFRegistered aircraftBuilt 2017 · S/N 680A0116N322CGCardinal Glass Industries Inc · Eden Prairie, MNBuilt 2022 · S/N 680A0301N323PGDsg Innovations LLC · Wilmington, DEBuilt 2010 · S/N 510-0288N323QSRegistered aircraftBuilt 2007 · S/N 680-0134N324DRTextron Aviation Inc · Wichita, KSBuilt 2009 · S/N 510-0271N324QSRegistered aircraftBuilt 2008 · S/N 680-0242N325HSD & D Air LLC · Baxter, MNBuilt 2010 · S/N 510-0325N326KFHuff Air LLC · Uvalde, TXBuilt 2010 · S/N 510-0326N327PDTurbojack LLC · Ridgeland, MSBuilt 2024 · S/N 680A0387N328NNicholas Services LLC · Oxford, MSBuilt 2015 · S/N 680A0008N32BROtis Air LLC · Orange Cove, CABuilt 2018 · S/N 680A0176N333HSN400 LLC · Conroe, TXBuilt 2011 · S/N 510-0370N333KGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0189N333MGMam Development LLC · Abingdon, VABuilt 2012 · S/N 680-0332N334QSRegistered aircraftBuilt 2007 · S/N 680-0164N337CMMustang Aero Consulting LLC · Waddell, AZBuilt 2011 · S/N 510-0337N339BConcord Jet Service Inc · Concord, CABuilt 2005 · S/N 680-0058N339QSRegistered aircraftBuilt 2008 · S/N 680-0191N341QSRegistered aircraftS/N 680-0225N34STIconic Aviation LLC · Mechanicsville, VABuilt 2009 · S/N 510-0205N356WABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 680-0512N357QSRegistered aircraftBuilt 2007 · S/N 680-0155N359QSRegistered aircraftBuilt 2007 · S/N 680-0126N35JBStella Maris LLC · Casper, WYBuilt 2010 · S/N 510-0284N35LSAerotrust Services Corp Trustee · Wilmington, DES/N 510-0248N361MLNew Mfis Holdings LLC · Henderson, NVBuilt 2010 · S/N 510-0316
Back to AD 2018-07-13