AD 2018-17-01

Registered aircraft · 147

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-17-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:2018-17-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.

N288DLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 32125N28VAVirginia State Police · Richmond, VABuilt 2019 · S/N 37045N300SJBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39142N303VSVertol Systems Company Inc · Destin, FLS/N 31303N306SBSan Bernardiino County Sheriffs Dept · San Bernardino, CABuilt 2023 · S/N 39116N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N308SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2023 · S/N 39114N310MPSuperior Aviation Solutions LLC · Mooresville, NCBuilt 1981 · S/N 31207N316LHLohman Helicopter LLC · Lewiston, IDBuilt 1977 · S/N 30817N34JJWestern USA Solutions Inc · Kodiak, AKS/N 36125N359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1972 · S/N 30546N366MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 36676N369ECEcolift Corp · San Juan, PRS/N 30671N373PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1979 · S/N 30934N374PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1979 · S/N 30931N376PAPathfinder Leasing LLC · Anchorage, AKBuilt 1978 · S/N 30886N377AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 37030N378PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30629N390BTBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39140N391BMBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39138N391TCBell Textron Inc · Fort Worth, TXS/N 39147N391TMBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39151N395BHBell Textron Inc · Fort Worth, TXS/N 39146N395BTBell Textron Inc · Fort Worth, TXBuilt 2026 · S/N 39158N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012N401TLTurbines Ltd · West Point, NES/N 36228N402ESNorth Slope Borough · Barrow, AKBuilt 1988 · S/N 33177N402TLFlorida State Guard · Tallahassee, FLBuilt 1998 · S/N 36212N409KCKern County Fire Department · Bakersfield, CABuilt 2024 · S/N 39128N40VACommonwealth Of Virgina Dept Of State Police · Richmond, VABuilt 2025 · S/N 39135N411DEU S Department Of Energy · Las Vegas, NVBuilt 1991 · S/N 36030N412ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 36320N412ADGeorgia Dept Of Public Safety · Kennesaw, GABuilt 2006 · S/N 36425N412ESAspen Helicopters Inc · Oxnard, CABuilt 2006 · S/N 36423N412ETEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 36395N412EXBell Textron Inc · Fort Worth, TXBuilt 2019 · S/N 39103N412FCity Of Houston · Houston, TXBuilt 1996 · S/N 36142N412TXBernailillo County Sheriffs Office · Albuquerque, NMBuilt 2010 · S/N 36550N412VCCounty Of Ventura Sheriffs Office · Camarillo, CABuilt 2022 · S/N 39108N412WPSalt River Project · Phoenix, AZBuilt 2022 · S/N 39106N417ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 36309N41VSVertol Systems Co Inc · Destin, FLS/N 31151N4359FPetroleum Helicopter Technology Inc · San Antonio, TXS/N 31117N470QLVertol Systems Co Inc · Destin, FLBuilt 1989 · S/N 33200N500EHHilcorp Equipment LLC · Anchorage, AKS/N 30945N508EHHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30908N512PAPatriot Aviation Inc · Greenville, DEBuilt 1984 · S/N 31268N515Savauge Air LLC · North Las Vegas, NVBuilt 1975 · S/N 30759N530NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1972 · S/N 30544N533NCStraight Up Leasing Inc · Medford, ORS/N 36403
Back to AD 2018-17-01