AD 2017-04-01

Registered aircraft · 377

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:2017-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-04-01')
  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.

N333MBWilmington Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 6588N33MSAir Kaitar LLC · Tallahassee, FLBuilt 2012 · S/N 6036N342ZKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6135N345LLSyl LLC · Miami, FLBuilt 2019 · S/N 6370N3546Nike Inc · Hillsboro, ORBuilt 2022 · S/N 6494N358VUS Bank Na · Marshall, MNBuilt 2015 · S/N 6161N361CZCorporate Wings LLC · Cleveland, OHBuilt 2015 · S/N 6109N365LGTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 6049N374FSTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2013 · S/N 6056N377LTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 6507N3788XBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 6578N380SECentral Pond Holdings LLC · Carson City, NVBuilt 2014 · S/N 6088N397RWRegistered aircraftBuilt 2019 · S/N 6397N3EDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 6523N3LBStellas Taxi LLC · Tampa, FLS/N 6123N400JJohnson & Johnson Finance Corp · New Brunswick, NJBuilt 2018 · S/N 6359N4050Registered aircraftBuilt 2019 · S/N 6368N4096Q6408 Equipment LLC · Portland, ORFirst renewal noticeBuilt 2019 · S/N 6408N40DWarbler I LLC · Freeland, MIBuilt 2014 · S/N 6119N415FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 6120N416ELC2 Aviation II LLC · Carson City, NVBuilt 2018 · S/N 6330N446CCD&Tc LLC · Carlsbad, NMBuilt 2016 · S/N 6238N449MTWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 6419N451CSGlobal Reach 18 LLC · Los Angeles, CABuilt 2019 · S/N 6372N456RABank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 6491N459BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6321N472USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6198N473USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6242N477RHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 6506N489KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6294N4APBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 6039N4FLFredex LLC · Rancho Santa Fe, CABuilt 2012 · S/N 6032N4KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 6583N510SRRelated 2019 LLC · New York, NYBuilt 2017 · S/N 6282N511DBSkybird Aviation Inc · Newport Beach, CABuilt 2013 · S/N 6058N515KAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 6028N516MFBakers Mf II LLC · Wilmington, DEBuilt 2024 · S/N 6572N516PLRsi650 LLC · Newport Beach, CABuilt 2011 · S/N 6015N517WBDiscovery Communications LLC · New York, NYBuilt 2023 · S/N 6554N519BHHilton Domestic Operating Company Inc · Mclean, VABuilt 2023 · S/N 6553N522MHBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 6486N524EABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 6444N540LFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 6474N545ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 6501N54BRRegistered aircraftBuilt 2018 · S/N 6355N555GATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6334N557ADGulfstream Flight Holdings LLC · New York, NYS/N 6329N566NSBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6180N585GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 6084N588SEBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 6455
Back to AD 2017-04-01