AD 2012-10-13

Registered aircraft · 13,306

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-10-13')
    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-10-13')
  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.

N34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeBuilt 1979 · S/N P21000307N34VMRoberts Glenn T · Port Orange, FLBuilt 1954 · S/N G-98N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597N34WGWings Of Grace Inc · Vonore, TNBuilt 2004 · S/N 0824N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258N350ABierlein Aviation LLC · Midland, MIBuilt 1977 · S/N 340A0325N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006N350BTAeroventure LLC · Middletown, DEBuilt 2006 · S/N 42537N350CWPrivate Flight LLC · Wilmington, DEBuilt 2006 · S/N 42520N350DGQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 42074N350ELCowick Glen M · Hollister, CABuilt 2001 · S/N ES-016-FBN350FJHafer Randall Frederick · Marietta, GABuilt 2008 · S/N 421008N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120N350LCDaly Arthur P · El Paso, TXBuilt 1978 · S/N P21000049N350PGGuerra Michael E · Kerrville, TXBuilt 2003 · S/N 42005N350RPShy Dennis · Cape Coral, FLBuilt 2004 · S/N 42046N350SFTakamatsu Hiroaki · Redmond, WAS/N 42062N350SLNeenair LLC · Danville, VABuilt 2006 · S/N 42526N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351N351CDRegistered aircraftBuilt 2026 · S/N 11184N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351PKK-Air Inc · Egg Harbor, WIBuilt 2025 · S/N 10857N351SREagle I LLC · Kalispell, MTBuilt 2009 · S/N 3571N351TWLlorca5 LLC · Bradenton, FLBuilt 2025 · S/N 10597N351VKFly Amelia LLC · Montclair, NJBuilt 2019 · S/N 1905N352JAPeterson Erik · Zeeland, MIBuilt 2008 · S/N 421005N352JSMccormick Kevin · Douglass, TXBuilt 2006 · S/N 42507N352KPN258wt LLC · Boca Raton, FLBuilt 2019 · S/N 4845N352MBD&D Aviation LLC · Brandon, MSBuilt 2025 · S/N 11074N352MMWindmill Aviation LLC · Sleepy Hollow, NYBuilt 2021 · S/N 5096N352MRN352mr LLC · Weldona, COBuilt 2006 · S/N 1782N352QWingstodieu LLC · Charlotte, NCBuilt 2025 · S/N 10967N352RCN352rc Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0186N352SRGulf Atlantic Airways Inc · Gainesville, FLBuilt 2006 · S/N 2030N352TImpact Aviation LLC · Ballwin, MOBuilt 1973 · S/N 340-0227N352TSBoss Contract Services LLC · Terry, MTBuilt 1972 · S/N 414-0352N352WTTinkerbell Holdings LLC · Tavares, FLBuilt 2010 · S/N 0005N353Giddings Thomas C · Fort Myers, FLBuilt 1999 · S/N AT-7N353CDSt Croix Leasing LLC · Fredonia, WIBuilt 2004 · S/N 1210N353GGrady Seamus Trustee · Pleasanton, CABuilt 2026 · S/N 11136N353KSReichard Leasing LLC · Harrisburg, PABuilt 2024 · S/N 10212N353PGDecarlo Rick P · Minden, NVBuilt 2004 · S/N 1115N353TCook Thedra K · Peachtree City, GABuilt 2006 · S/N LIV 293N35443Registered aircraftBuilt 1973 · S/N 21059992N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485N354BWCarpenter Richard A · Hermiston, ORBuilt 1979 · S/N EA-40N354EMSrm Aviation Solutions LLC · Richland, WABuilt 2007 · S/N 2634N354FCBlue Sky November LLC · Mamaroneck, NYBuilt 2020 · S/N 4875N354SNKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2016 · S/N 1354
Back to AD 2012-10-13