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.

N24268Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13161N24280Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13183N24281Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13185N24283Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13186N24285Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13188N242AKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 172S11091N242AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13204N242EPEpic Aviation Inc · New Smyma Beach, FLBuilt 2024 · S/N 172S13243N242JWAviation Leasing Co LLC · Ooltewah, TNBuilt 2019 · S/N 172S12279N242RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11131N242RT9614m Aviation LLC · Boynton Beach, FLS/N 17280537N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226N242TWTw Airplane LLC · San Antonio, TXBuilt 2005 · S/N 172S9896N24314Weirich William T Jr · Waterman, ILBuilt 2000 · S/N 17280864N24318Milo Technologies LLC · Woodstock, GABuilt 2001 · S/N 17280994N2432KChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280870N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887N24336Moody Bible Institute Of Chicago · Spokane, WABuilt 2000 · S/N 17280888N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144N24352National Training I LLC · Wilmington, DEBuilt 2000 · S/N 17280835N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223N243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874N2446ZEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10118N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801N2447DAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280803N24483Fly 172r LLC · Peoria, AZBuilt 2000 · S/N 17280982N2448BChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280978N244AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13224N244EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13283N2451NHoelscher Carl D · Garden City, TXBuilt 2001 · S/N 17280989N24529Rainier Flight Service LLC · Renton, WABuilt 2001 · S/N 17281014N24547Gryphon Aviation Inc · San Marcos, TXBuilt 1999 · S/N 17280796N2454ESky Mates Inc · Wilmington, DEBuilt 2007 · S/N 172S10571N2454VMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8816N24576Board Of Supervisors Of The University Of La Syst · Ruston, LABuilt 2000 · S/N 17280892N2458GSilver Express Co DBA · Miami, FLBuilt 2000 · S/N 17280893
Back to AD 2012-22-01