OpenAirDocs.org
AD 2023-01-12

Registered aircraft · 39

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

N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760N135TGAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0298N145GRegistered aircraftBuilt 2015 · S/N 20044N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N30EZHover Air LLC · Anchorage, AKBuilt 2011 · S/N 7285N350MPCity Of Memphis Police Department · Memphis, TNBuilt 2004 · S/N 3783N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788N365JLBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 6438N365MMCampell Michael W · Fayetteville, TNBuilt 1994 · S/N 6465N365MYIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6325N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239N387AK387ak LLC · Anchorage, AKS/N 3730N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024N403HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1999 · S/N 6570N444KLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2008 · S/N 9010N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733N611LLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1994 · S/N 6476N614ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 6319N666HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1995 · S/N 6494N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807N919SFAir Er LLC · Corinth, TXBuilt 1991 · S/N 760370N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 20161N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461
Back to AD 2023-01-12