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.

N761EUMelvey Jay R · Westminster, COBuilt 1977 · S/N 21062205N761EWInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 21062207N761EZState Of Arizona · Prescott, AZBuilt 1977 · S/N 21062210N761FBVitatoe Industries Inc · Chillicothe, OHBuilt 1977 · S/N 21062212N761FCFrenchman Valley Produce Inc · Imperial, NEBuilt 1977 · S/N 21062213N761FKSunset Cattle Co LLC · Los Banos, CABuilt 1977 · S/N 21062220N761FQBalderrama Rocio Ovando · El Paso, TXBuilt 1977 · S/N 21062225N761GBFerguson Robert Martin Todd · Carlisle, ARBuilt 1977 · S/N 21062236N761GETeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 21062239N761GYOff We Go LLC · Fort Collins, COBuilt 1977 · S/N 21062257N761HCZimmermann Fredric M · Granbury, TXBuilt 1977 · S/N 21062261N761HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 21062263N761HNA-1 American Fence Inc · Orange, TXBuilt 1977 · S/N 21062271N761HSLassetair LLC · Glen Ellen, CABuilt 1977 · S/N 21062275N761HTWieckowski Peter · Boxford, MABuilt 1977 · S/N 21062276N761HVResultant Aviation LLC · Orlando, FLBuilt 1977 · S/N 21062278N761JDRj Aviation LLC · Byhalia, MSBuilt 1977 · S/N 21062286N761JK926-928 Newton LLC · Denver, COS/N 21062292N761JMFour Star Ranch Inc · Randlett, UTS/N 21062294N761KBOne Kilo Bravo · Renton, WABuilt 1977 · S/N 21062307N761KVDiamond X Aviation LLC · Johnson City, TXBuilt 1977 · S/N 21062325N761LBDiamond 210 LLC · Dover, DEBuilt 1977 · S/N 21062331N761LGTrinkle Aviation LLC · Kingsburg, CAS/N 21062336N761LMDyer J Scott · Pleasantville, NYBuilt 1977 · S/N 21062341N761LUStowell Robert W · La Porte, INBuilt 1977 · S/N 21062348N761MERoseburg Skyways LLC · Livermore, CAS/N 21062357N761MJFritz Mark Andrew · Williamson, GABuilt 1977 · S/N 21062361N761MSHarvey Scott · Hereford, AZBuilt 1977 · S/N 21062369N761PPSoheily Holdings LLC · Austin, TXBuilt 1977 · S/N 21062412N761PRBluff City Bell LLC · Caldwell, IDBuilt 1977 · S/N 21062414N761QAErnst Gary W · Emerald Hills, CABuilt 1977 · S/N 21062423N761QXAerial Art Photography · Altadena, CABuilt 1978 · S/N 21062444N761RCClannalu Air LLC · Midland, TXBuilt 1978 · S/N 21062449N761RDRobinson John · Farmington, NMBuilt 1978 · S/N 21062450N761RESecrest Steven J · Roosevelt, UTBuilt 1978 · S/N 21062451N761RGBas Part Sales LLC · Greeley, COS/N 21062453N761RLCampbell Gordon S · Concord, CABuilt 1978 · S/N 21062457N761SBBracl Holdings LLC · Tonganoxie, KSBuilt 1978 · S/N 21062471N761SGThurmond Clark · Georgetown, TXBuilt 1978 · S/N 21062476N761SHJs Flying Services LLC · Reno, NVBuilt 1978 · S/N 21062477N761SRNikitin Alexey Pavlovich · Tigard, ORBuilt 2003 · S/N 40069N761STBode Aviation Inc · Albuquerque, NMBuilt 1978 · S/N 21062487N761TCMichigan Scientific Corp · Milford, MIBuilt 1978 · S/N 21062496N761THBlack Forest Wings LLC · Noblesville, INBuilt 1978 · S/N 21062501N761TKRichards And Richards · Nucla, COBuilt 1978 · S/N 21062503N761TLOmni International Services Inc · Reno, NVBuilt 1978 · S/N 21062504N761TMHwbec761 LLC · Los Ranchos, NMBuilt 1978 · S/N 21062505N761TYAdw N761ty LLC · Chicago, ILBuilt 1978 · S/N 21062516N761VWKennedy M John · Gillette, WYBuilt 1978 · S/N 21062562N761WHPierson Tim E · Gooding, IDBuilt 1978 · S/N 21062573
Back to AD 2012-10-13