AD 2018-04-13

Registered aircraft · 1,373

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-04-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-04-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.

N673PPRegistered aircraftBuilt 2023 · S/N 20972N674EFEdinton Holdings USA Inc · Miami, FLBuilt 2025 · S/N 21063N675LCRockies West LLC · Eugene, ORBuilt 2006 · S/N 20097N680WAWonderful Orchards LLC · Bakersfield, CABuilt 2018 · S/N 2143N682EEPraetor Ssi LLC · Lighthouse Point, FLBuilt 2024 · S/N 55020182N685ARBua Delaware Inc · Wilmington, DEBuilt 2023 · S/N 20962N686BERegistered aircraftBuilt 2019 · S/N 2192N686CBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20604N686CGRegistered aircraftBuilt 2022 · S/N 20911N6872Sage Moon Air LLC · Salt Lake City, UTBuilt 2012 · S/N 2010N695BAFlying Strategies LLC · Garland, TXBuilt 2009 · S/N 20273N696HCRegistered aircraftBuilt 2025 · S/N 2311N696HQRegistered aircraftBuilt 2015 · S/N 2078N697CCRegistered aircraftBuilt 2014 · S/N 2058N699PBSuperior Products 2 LLC · South Plainfield, NJBuilt 2023 · S/N 20958N699SCRegistered aircraftBuilt 2024 · S/N 2280N69AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 2273N700BCTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2010 · S/N 20297N700RHRite Direction Corp · Milwaukee, WIBuilt 2023 · S/N 2266N7011MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 21092N701QSRegistered aircraftBuilt 2019 · S/N 20797N702QSRegistered aircraftBuilt 2019 · S/N 20801N702RWEcl Leasing LLC · Las Vegas, NVBuilt 2012 · S/N 20350N703DSJd Stauffer LLC · Nokomis, FLBuilt 2022 · S/N 55020174N703QSRegistered aircraftBuilt 2019 · S/N 20807N704JBJimmie Johnson Racing II Inc · Birmingham, MIBuilt 2012 · S/N 20376N704LBRhcp 280 LLC · West Chicago, ILBuilt 2019 · S/N 2197N705QSRegistered aircraftBuilt 2019 · S/N 20809N706QSRegistered aircraftBuilt 2019 · S/N 20812N707KGBbhco LLC · Los Angeles, CABuilt 2009 · S/N 20283N707MHDrg Challenge LLC · Sonoma, CABuilt 2023 · S/N 20966N707QSNetjets Sales Inc · Oklahoma City, OKBuilt 2019 · S/N 20818N707SCS Cole Aviation LLC · Midland, TXBuilt 2005 · S/N 20081N707SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20806N708QCindago LLC · Rancho Cucamonga, CABuilt 2020 · S/N 20842N708QSRegistered aircraftBuilt 2025 · S/N 21100N709QSBarnhart Interests Inc · Oklahoma City, OKBuilt 2026 · S/N 21105N70CRWorld Wing Sales LLC · Pearland, TXBuilt 2005 · S/N 20048N70RLBs Aviation Holdings II LLC · Englewood, COBuilt 2007 · S/N 20159N710BAContrail Aviation LLC · Philadelphia, PABuilt 2013 · S/N 2036N710ECChouest Air Inc · Galliano, LABuilt 2018 · S/N 2153N710QSAir To Land LLC · Oklahoma City, OKBuilt 2026 · S/N 21109N711HAHoyt Air Inc · Phoenix, AZBuilt 2013 · S/N 20419N711QSCiena Corp · Oklahoma City, OKBuilt 2026 · S/N 21111N712AQRrp Aviation LLC · Dover, DEBuilt 2006 · S/N 20127N712BHProject Finance Inc · Ada, MIBuilt 2016 · S/N 20615N712WBBlessey Aviation LLC · Big Sky, MTBuilt 2023 · S/N 20946N713BLBmb Aircraft LLC · Oklahoma City, OKBuilt 2023 · S/N 2271N713DHHigginbotham Management Co Inc · New Smyrna Beach, FLBuilt 2023 · S/N 20951N713SSDream Catcher 2020 LLC · East Helena, MTBuilt 2015 · S/N 2070
Back to AD 2018-04-13