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.

N59EPP77 LLC · Ketchum, IDBuilt 2013 · S/N 2034N59JSValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 55020208N59KGRegistered aircraftBuilt 2013 · S/N 20393N59MGHedwig 1 LLC · Wapiti, WYBuilt 2020 · S/N 55020129N5LAir Sansone LLC · Wilmington, DEBuilt 2006 · S/N 20101N600ARSel Aircraft LLC · Bristol, INBuilt 2023 · S/N 55020172N600AWRegistered aircraftBuilt 2022 · S/N 55020166N600CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20191N600CHAllegiance I LLC · Columbus, OHBuilt 2019 · S/N 55010054N600DHDrury Development Corp · St Louis, MOBuilt 2026 · S/N 55020258N600FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 55020159N600HZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 55020109N600JTMountain Air Charter LLC · Dallas, TXBuilt 2024 · S/N 55020200N600NXAkima LLC · Herndon, VABuilt 2020 · S/N 55020128N600RXDynasty Jet LLC · Naples, FLBuilt 2021 · S/N 55020150N601FXGillman Chris · Cleveland, OHBuilt 2022 · S/N 55020164N602FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 55020171N603FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55020185N603GPN603gp LLC · Dover, DEBuilt 2016 · S/N 20660N603HC13400 South 54 Holdings LLC · Lincoln, NEBuilt 2024 · S/N 55020203N604DDominion Energy Services Inc · Richmond, VABuilt 2014 · S/N 2046N605FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55020192N605HPPalmetto Express Company LLC · Wilmington, DEBuilt 2020 · S/N 20847N606AFVela Flight LLC · Camarillo, CABuilt 2025 · S/N 55020246N606FXMalayer Management Sub I LLC · Cleveland, OHBuilt 2024 · S/N 55020205N606RPSydes Aviation LLC · Jacksonville, NCBuilt 2010 · S/N 20309N607DXDsg Finance LLC · Coraopolis, PABuilt 2023 · S/N 2269N607FXClinical Ventures Group II LLC · Cleveland, OHBuilt 2024 · S/N 55020207N607GJGabinoah LLC · Miami Beach, FLBuilt 2013 · S/N 20414N608ABCl350 20589 LLC · Missoula, MTBuilt 2015 · S/N 20589N608FXFlexjet LLC · Cleveland, OHBuilt 2024 · S/N 55020209N608KHIronwood Sky Holdings LLC · Wilmington, DEBuilt 2008 · S/N 20237N608RPWheels Up Partners LLC · New York, NYBuilt 2012 · S/N 20372N608TBFsi Inc · Portage, WIBuilt 2015 · S/N 55000026N609FXGriffin Capital LLC · Cleveland, OHBuilt 2024 · S/N 55020210N60CKJurie Jet LLC · Frederick, MDBuilt 2014 · S/N 20512N610CGMac Air LLC · Sellersburg, INBuilt 2008 · S/N 20241N610DPWestair Corp · Lexington, SCBuilt 2016 · S/N 2104N610FXRoger Ferris & Partners LLC · Cleveland, OHBuilt 2024 · S/N 55020217N610HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20185N611AVCyprus Center Services LLC · Gilbert, AZBuilt 2017 · S/N 20693N611FXMobiscrypt LLC · Cleveland, OHBuilt 2024 · S/N 55020218N612FXAeromarine Holdings LLC · Cleveland, OHBuilt 2025 · S/N 55020235N613FXAir Dragon LLC · Cleveland, OHBuilt 2025 · S/N 55020233N613LSCarlton Place Leasing LLC · Boca Raton, FLBuilt 2020 · S/N 20841N614FXBird By Bird LLC · Cleveland, OHBuilt 2025 · S/N 55020248N614THThorpe LLC · Jupiter, FLBuilt 2015 · S/N 55000012N614WDCharlie 350 LLC · Columbus, OHBuilt 2020 · S/N 20844N615TKMash Aviation LLC · Nashville, TNBuilt 2015 · S/N 55000006N615WDCharlie 300 LLC · Columbus, OHBuilt 2013 · S/N 20415
Back to AD 2018-04-13