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.

N570PKPrimoris Services Corp · Dallas, TXBuilt 2016 · S/N 680-0557N570QSRegistered aircraftBuilt 2018 · S/N 680A0125N571QSRegistered aircraftBuilt 2018 · S/N 680A0126N572QSRegistered aircraftBuilt 2018 · S/N 680A0133N574TDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 510-0446N576MCAlliant Equipment Leasing LLC · Cape Girardeau, MOBuilt 2007 · S/N 510-0017N578CMBerg Randolph M Trustee · Corona Del Mar, CABuilt 2010 · S/N 510-0292N578QSRegistered aircraftBuilt 2018 · S/N 680A0135N580RMWings Jet Flight Training LLC · Los Angeles, CAS/N 510-0242N581QSRegistered aircraftBuilt 2018 · S/N 680A0137N582QSRegistered aircraftBuilt 2018 · S/N 680A0138N584QSRegistered aircraftBuilt 2018 · S/N 680A0139N585QSRegistered aircraftBuilt 2018 · S/N 680A0141N586QSRegistered aircraftBuilt 2018 · S/N 680A0142N58EPSel Services LLC · Houston, TXBuilt 2017 · S/N 680-0571N58WEBoomer Air LLC · Conway, ARBuilt 2016 · S/N 680A0025N591QSRegistered aircraftBuilt 2018 · S/N 680A0144N593QSRegistered aircraftBuilt 2018 · S/N 680A0145N595ABFreedom Isnt Free LLC · Laguna Beach, CABuilt 2006 · S/N 680-0090N595AGGrowmark Inc · Bloomington, ILBuilt 2018 · S/N 680A0169N595QSRegistered aircraftBuilt 2018 · S/N 680A0146N595RHTextron Aviation Inc · Wichita, KSS/N 680A0498N596QSRegistered aircraftBuilt 2018 · S/N 680A0153N597QSRegistered aircraftBuilt 2018 · S/N 680A0156N598QSRegistered aircraftBuilt 2018 · S/N 680A0157N59TFKlp Air LLC · Cincinnati, OHBuilt 2011 · S/N 680-0311N59VMDvbmc LLC · Heath, TXBuilt 2009 · S/N 510-0181N5NRL & F Arrow LLC · Mcallen, TXBuilt 2020 · S/N 680A0239N600BR486 Leasing LLC · Jupiter, FLBuilt 2026 · S/N 680A0486N600LRegistered aircraftBuilt 2019 · S/N 680A0217N600LNRegistered aircraftBuilt 2019 · S/N 680A0218N601FMSprouts Farmers Markets Holdings LLC · Phoenix, AZBuilt 2017 · S/N 680A0117N601QSRegistered aircraftBuilt 2019 · S/N 680A0231N603NEBsp603 LLC · Manchester, NHBuilt 2017 · S/N 680A0103N603QSRegistered aircraftBuilt 2018 · S/N 680A0159N603WSClint Newell Motors Inc · Roseburg, ORBuilt 2009 · S/N 510-0215N604QSRegistered aircraftBuilt 2018 · S/N 680A0160N605QSRegistered aircraftBuilt 2021 · S/N 680A0284N606AWAurora Ventures LLC · Saint Paul, MNBuilt 2021 · S/N 680A0281N606QSRegistered aircraftBuilt 2021 · S/N 680A0262N607QSRegistered aircraftBuilt 2021 · S/N 680A0264N608ESTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 680A0487N608QSRegistered aircraftBuilt 2020 · S/N 680A0255N60CPIp Capital Assets LLC · Granger, INBuilt 2008 · S/N 510-0064N60EXPrent Corp · Janesville, WIBuilt 2024 · S/N 680A0394N610PTN610pt LLC · Etna, OHBuilt 2009 · S/N 510-0172N610QSRegistered aircraftBuilt 2018 · S/N 680A0161N611GLTrinity 21 LLC · Old Town, FLBuilt 2012 · S/N 510-0400N612JDOtd Aviation LLC · Bethesda, MDBuilt 2019 · S/N 680-0585N612QSRegistered aircraftBuilt 2020 · S/N 680A0256
Back to AD 2018-07-13