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.

N550BRF P And P I Enterprises Inc · Oceanside, CABuilt 1974 · S/N 414-0533N550CDCoen Scott D · Kingsport, TNBuilt 2004 · S/N 1124N550EFSteinbruegge David M · Durango, COBuilt 2012 · S/N L2K-332N550FK38884 LLC · Moorhead, MNBuilt 1977 · S/N 18503229N550GKGreen Of Peak LLC · San Francisco, CABuilt 2014 · S/N 0805N550GRClark Robert E · Meridian, MSBuilt 2001 · S/N 40015N550JKTaffet Jay · New Orleans, LABuilt 1986 · S/N 46-8608041N550KBPradelt Charles · Queen Creek, AZBuilt 2001 · S/N ES-126-FBN550KCRegistered aircraftBuilt 2011 · S/N 299N550LWWasserott Charles G · Owasso, OKBuilt 2001 · S/N ES 116N550MHAviation Education Services Inc · Tetonia, IDS/N 11790-2N550MPPal Aviation LLC · Natchez, MSBuilt 1986 · S/N 4608041N550NCTri-State Communications Inc · South Sioux City, NEBuilt 1988 · S/N CE-1241N550RESimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 21060968N550RGBr Ventures LLC · Port Orange, FLBuilt 2005 · S/N 1635N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516N550RXRegistered aircraftBuilt 2017 · S/N 78N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086N5511CDss Consulting LLC · Omaha, NEBuilt 1979 · S/N 21063772N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142N5516CCarson Kirk · Dalhart, TXBuilt 1979 · S/N 21063774N5517UKoegel John C · Flint, MIBuilt 1984 · S/N 21064897N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519N551ATCorellian Spacecraft LLC · Leesburg, VABuilt 2021 · S/N 5149N551BPPalmer John Michael · Saint Louis, MOBuilt 2007 · S/N 2876N551CDBwr Group LLC · Hobbs, NMBuilt 2005 · S/N 1550N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158N551JWDepato LLC · Paradise Valley, AZBuilt 2013 · S/N 0454N551SGAviation Module LLC · Los Angeles, CABuilt 2017 · S/N 4562N551SRN551sr Aviation LLC · Roswell, GABuilt 2006 · S/N 2126N551USFar Side Aero LLC · Santa Maria, CABuilt 2005 · S/N 29-0351N5522COswald Ron · Eden Prairie, MNBuilt 1986 · S/N 21064973N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N5527AMokiy LLC · Aurora, ORBuilt 1985 · S/N P21000861N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N552AMCirrus Sr22t 0189 Inc Trustee · Wilmington, DEBuilt 2011 · S/N 0189N552CDDirect Internet Inc · Harsens Islands, MIS/N 0922N552CMCm552 LLC · Katy, TXBuilt 2000 · S/N E-3337N552FSSciortino Frank M · Oswego, NYBuilt 2023 · S/N 9552N552SRGenung Tobin J · Ocala, FLBuilt 2007 · S/N 2278N552ZSTuolumne Ridge LLC · Modesto, CABuilt 1983 · S/N EA-343N5530XFaulhaber Orlin W · North Platte, NEBuilt 1989 · S/N E-2504N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506
Back to AD 2012-10-13