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.

N921TXJetthane Aviation LLC · Fort Myers, FLBuilt 2008 · S/N 510-0071N922QSRegistered aircraftBuilt 2022 · S/N 680A0331N9233Wadler Manufacturing Company Inc · Galena, KSBuilt 2008 · S/N 510-0097N923QSRegistered aircraftBuilt 2023 · S/N 680A0350N924QSRegistered aircraftBuilt 2023 · S/N 680A0351N925QSRegistered aircraftBuilt 2023 · S/N 680A0352N926QSRegistered aircraftBuilt 2023 · S/N 680A0353N927ACFamous Pawn Inc · Baltimore, MDBuilt 2008 · S/N 680-0202N927GMSjm Assets LLC · Houston, TXBuilt 2009 · S/N 680-0285N927QSRegistered aircraftBuilt 2023 · S/N 680A0354N928QSRegistered aircraftBuilt 2023 · S/N 680A0356N929QSRegistered aircraftBuilt 2023 · S/N 680A0358N929STShowtech Aviation Inc · Poway, CABuilt 2010 · S/N 510-0352N92AJMaxq LLC · Livonia, MIBuilt 2016 · S/N 680A0034N930MGGonsalves And Santucci Inc · Concord, CABuilt 2007 · S/N 680-0152N930QSRegistered aircraftBuilt 2023 · S/N 680A0359N931QSRegistered aircraftBuilt 2023 · S/N 680A0360N932JSEnola Gay LLC · Kinston, NCBuilt 2007 · S/N 680-0135N932QSRegistered aircraftBuilt 2023 · S/N 680A0361N933QSRegistered aircraftBuilt 2023 · S/N 680A0362N934QSRegistered aircraftBuilt 2023 · S/N 680A0363N935EFTroy Aviation LLC · Birmingham, MIBuilt 2017 · S/N 680A-0075N935QSRegistered aircraftBuilt 2023 · S/N 680A0364N936JSPdia LLC · Austin, TXBuilt 2007 · S/N 680-0165N936QSRegistered aircraftBuilt 2023 · S/N 680A0365N937QSRegistered aircraftBuilt 2023 · S/N 680A0366N938QSRegistered aircraftBuilt 2023 · S/N 680A0371N939CFMch Aviation LLC · San Antonio, TXBuilt 2006 · S/N 680-0056N939QSRegistered aircraftBuilt 2023 · S/N 680A0372N93KMHorizons Unlimited Air Inc · Hillsboro, ORBuilt 2016 · S/N 510-0465N940JFNucor Corp · Charlotte, NCBuilt 2016 · S/N 680A0038N940QSRegistered aircraftBuilt 2023 · S/N 680A0373N941QSRegistered aircraftBuilt 2023 · S/N 680A0374N942JSAltitude One Holdings LLC · Miami, FLBuilt 2005 · S/N 680-0033N942QSRegistered aircraftBuilt 2023 · S/N 680A0375N943FLFlorida Department Of Law Enforcement · Tallahassee, FLBuilt 2019 · S/N 680A0234N943JSBhh Aviation LLC · Kinston, NCBuilt 2005 · S/N 680-0046N943QSRegistered aircraftBuilt 2024 · S/N 680A0376N944QSRegistered aircraftBuilt 2024 · S/N 680A0377N945QSRegistered aircraftBuilt 2024 · S/N 680A0378N946QSRegistered aircraftBuilt 2024 · S/N 680A0379N947QSRegistered aircraftBuilt 2024 · S/N 680A0380N948QSRegistered aircraftBuilt 2024 · S/N 680A0381N949JBRetirement Piper LLC · North Kingstown, RIBuilt 2009 · S/N 510-0218N949QSRegistered aircraftBuilt 2024 · S/N 680A0382N950JSN1jn-Sov LLC · Juno Beach, FLBuilt 2007 · S/N 680-0120N950QSRegistered aircraftBuilt 2024 · S/N 680A0383N950SDSd Air LLC · Houston, TXBuilt 2005 · S/N 680-0042N951QSRegistered aircraftBuilt 2024 · S/N 680A0384N952PJ63 LLC · Memphis, TNBuilt 2016 · S/N 680A0020
Back to AD 2018-07-13