AD 2012-22-01

Registered aircraft · 3,852

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:2012-22-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:2012-22-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.

N227CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13049N227TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9227N227WCHuerta Holdings Inc · Woodland Hills, CABuilt 2005 · S/N 172S9844N22801Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12906N22803Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12908N22806Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12911N22807Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12914N22808Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12915N22809Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12919N22810Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12921N22813Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12924N22816Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12925N22818Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12929N228TWNorth Delta Aviation LLC · Blytheville, ARBuilt 2002 · S/N 172S9228N22904Phoenix East Aviation LLC · Daytona Beach, FLS/N 172S9961N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959N2291CForty Four Fifteen LLC · Reno, NVBuilt 2005 · S/N 172S9962N2296NMacsdea LLC · Van Nuys, CABuilt 2005 · S/N 172S9967N2298WGoli Aviation LLC · Raleigh, NCBuilt 2005 · S/N 172S9968N229METom Wood Aviation Inc · Fishers, INBuilt 2000 · S/N 172S8483N229WCJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2016 · S/N 172S11669N22SJWright James M · San Diego, CABuilt 1999 · S/N 172S8345N2302YMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9973N230EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13092N230KGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13468N230SAStature Aviation LLC · Addison, TXBuilt 2025 · S/N 172S13435N23104Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13045N23107Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13105N23108Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13100N23110Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13104N23116Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13106N23118Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13107N23120Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13108N23122Atp Aircraft 1 LLC · Wilmington, DES/N 172S13110N23124Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13111N23127Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13112N23134Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13189N23137Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13191N2316TAircraft Solutions Group LLC · Englewood, COBuilt 1999 · S/N 17280694N23172Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13192N23175Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13194N23176Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13195N23177Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13197N231EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13093N23203Wings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 17280696N2322YIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 172S9985N2328RYoung Airmans Association Inc · Arverne, NYBuilt 2005 · S/N 172S9989N232EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13095N232FFArq Aviation LLC · Wilmington, NCBuilt 2026 · S/N 172S13571N2330FFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9992
Back to AD 2012-22-01