OpenAirDocs.org
AD 2018-01-12 R1

Registered aircraft · 646

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-01-12-R1')
    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-01-12-R1')
  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.

N352HDT Scott Dunn Construction Inc DBA · Phoenix, ORBuilt 2001 · S/N 3442N352HPState Of Utah · Salt Lake City, UTBuilt 2015 · S/N 8097N352PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3378N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664N352SASycan Corp DBA · Paso Robles, CAS/N 3348N353CEAviation Advantage Inc · Tabor City, NCBuilt 2008 · S/N 4575N353EReeder Flying Service Inc · Twin Falls, IDBuilt 2012 · S/N 7498N353FBNs Air Leasing LLC · Wilmington, DEBuilt 2005 · S/N 3926N353HPState Of Utah · Salt Lake City, UTBuilt 2021 · S/N 9114N353JRPrecision LLC · Mcminnville, ORBuilt 2014 · S/N 7975N353MHPathfinder Leasing LLC · Anchorage, AKBuilt 1999 · S/N 3267N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722N353SHSycan Corp DBA · Paso Robles, CABuilt 2002 · S/N 3524N354CFTristate Careflight LLC · Greenwood Village, COBuilt 2008 · S/N 4526N354EReeder Flying Service Inc · Twin Falls, IDBuilt 2013 · S/N 7711N354HPState Of Utah · Salt Lake City, UTBuilt 2022 · S/N 9146N354LASale Reported · Milton, VTSale reported, canceledS/N 3285N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690N354PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3330N354SHSycan Corp DBA · Paso Robles, CABuilt 1998 · S/N 3131N355AMAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9864N355CFAir Methods LLC · Greenwood Village, COS/N 4644N356KJB&R Trucking Inc · Carlsbad, NMBuilt 2020 · S/N 8833N356PPhi Health LLC · Tempe, AZBuilt 2015 · S/N 8014N357KVKavecol Inmobiliaria Inc · Guaynabo, PRS/N 7672N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675N358PAPathfinder Leasing LLC · Anchorage, AKBuilt 1999 · S/N 3245N358SHSycan Corp DBA · Paso Robles, CABuilt 2012 · S/N 7440N359EVAlaska Remote Outfitters LLC · Kenai, AKS/N 3797N359FBPhoenix Police Department · Phoenix, AZBuilt 2009 · S/N 4660N359PANs Air Leasing LLC · Wilmington, DEBuilt 2000 · S/N 3329N359SHPaso Air Leasing LLC · Paso Robles, CABuilt 2022 · S/N 9167N35HXHelicopter Express LLC · Chamblee, GABuilt 2014 · S/N 7980N361TXTexas Department Of Public Safety · Austin, TXBuilt 2023 · S/N 9450N362ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 7290N364TARoberts Aircraft LLC · Cheyenne, WYS/N 7593N369WMTeam C & H Inc · Jacksonville, FLBuilt 2019 · S/N 8652N370HPOklahoma Department Of Public Safety · Norman, OKBuilt 2013 · S/N 7598N370NCState Of North Carolina · Raleigh, NCBuilt 2008 · S/N 4379N370SRDepartment Of Homeland Security · Washington, DCBuilt 2023 · S/N 9325N377GRAirbus Helicopters Inc · Grand Prairie, TXS/N 9985N381ZDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 9101N382BMCity Of San Antonio · San Antonio, TXBuilt 2023 · S/N 9388N382PPhi Health LLC · Tempe, AZBuilt 2014 · S/N 7920N3831Air Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3947N383AKAlpha Aviation LLC · Anchorage, AKBuilt 2002 · S/N 3530N384PPhi Health LLC · Tempe, AZBuilt 2014 · S/N 7928N385AKAlpha Aviation LLC · Anchorage, AKBuilt 1998 · S/N 3128N386AKAlpha Aviation LLC · Anchorage, AKBuilt 2000 · S/N 3336N386PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7638
Back to AD 2018-01-12 R1