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.

N884TMFiesta Foods Of Oregon Inc · Hermiston, ORFirst renewal noticeBuilt 2009 · S/N 510-0180N885JSSky Crossings II LLC · Charleston, SCBuilt 2013 · S/N 680-0508N885RSChronos Aviation Group LLC · Chandler, AZBuilt 2011 · S/N 510-0389N888GSCmi Holdings LLC · Aspen, COBuilt 2009 · S/N 510-0209N888SFAerospace Holdings LLC · Lawrence, KSBuilt 2007 · S/N 680-0154N889DFStrain Aviation LLC · Abita Springs, LABuilt 2005 · S/N 680-0018N88CHRegistration Pending · Boise, IDRegistration pendingBuilt 2009 · S/N 510-0224N88JJSterling Motors Ltd · Newport Beach, CABuilt 2009 · S/N 680-0277N893MCMike Charlie LLC · Mobile, ALBuilt 2008 · S/N 510-0120N894KSKs Air Charter LLC · Bakersfield, CABuilt 2016 · S/N 680A0031N898CVpj Flight Services LLC · Oxford, MSBuilt 2026 · S/N 680A0478N899JFBuildair LLC · Bridgehampton, NYBuilt 2007 · S/N 680-0122N900CMCharter Airplane Holding Company LLC · Mequon, WIBuilt 2019 · S/N 680-0591N900QSRegistered aircraftBuilt 2022 · S/N 680A0306N901QSRegistered aircraftBuilt 2022 · S/N 680A0307N902LGN324ab LLC · Madison, SDBuilt 2008 · S/N 510-0066N902QSRegistered aircraftBuilt 2022 · S/N 680A0314N903JPMustang Systems LLC · Oakland, CABuilt 2008 · S/N 510-0102N904HDHdr Construction Control Corp · Omaha, NEBuilt 2019 · S/N 680A0204N904QSRegistered aircraftBuilt 2022 · S/N 680A0318N905QSBlue & Red Devils LLC · Columbus, OHBuilt 2022 · S/N 680A0319N906QSRegistered aircraftBuilt 2022 · S/N 680A0320N907QSRegistered aircraftBuilt 2022 · S/N 680A0321N907RPJwt Equipment LLC · Springdale, ARBuilt 2008 · S/N 680-0251N908QSRegistered aircraftBuilt 2022 · S/N 680A0322N909QSRegistered aircraftBuilt 2022 · S/N 680A0323N910GFCorsair Two LLC · Hillsboro, ORBuilt 2012 · S/N 510-0425N910QSRegistered aircraftBuilt 2022 · S/N 680A0324N910SSBadlands Aviation LLC · Watford City, NDBuilt 2019 · S/N 680A0236N912JDVandelay Aviation LLC · Silver Spring, MDBuilt 2014 · S/N 510-0453N912QSRegistered aircraftBuilt 2022 · S/N 680A0333N913QSRegistered aircraftBuilt 2022 · S/N 680A0334N913TWCarolina Girl LLC · Kennesaw, GABuilt 2020 · S/N 680A0221N914GPacific Aerostar LLC · Sonoma, CABuilt 2009 · S/N 510-0239N914GWDunrovin Aviation LLC · Salem, VABuilt 2008 · S/N 510-0146N914QSRegistered aircraftBuilt 2023 · S/N 680A0335N915CFAdvantage Leasing LLC · Franklin, TNBuilt 2007 · S/N 510-0014N915QSRegistered aircraftBuilt 2023 · S/N 680A0336N916QSRegistered aircraftBuilt 2023 · S/N 680A0337N917FHBluesky9 Consulting LLC · Scottsdale, AZBuilt 2015 · S/N 680A0004N917QSRegistered aircraftBuilt 2023 · S/N 680A0338N918EBBaccharis Capital LLC · Atherton, CABuilt 2012 · S/N 680-0343N918QSRegistered aircraftBuilt 2023 · S/N 680A0339N918WABlueskin Aviation LLC · Dallas, TXBuilt 2009 · S/N 510-0237N919QSRegistered aircraftBuilt 2023 · S/N 680A0341N91CHU K Capital · Scottsdale, AZBuilt 2009 · S/N 510-0201N91FPJet There LLC · Cedar Rapids, IABuilt 2008 · S/N 510-0001N91MBBretz-Aztec LLC · Missoula, MTBuilt 2010 · S/N 510-0310N920QSRegistered aircraftBuilt 2023 · S/N 680A0342N921QSRegistered aircraftBuilt 2023 · S/N 680A0344
Back to AD 2018-07-13