AD 2012-11-05

Registered aircraft · 305

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-11-05')
    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-11-05')
  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.

N51699Styer David B · Pendleton, ORBuilt 1977 · S/N 416N516BYIberlin James M · Gillette, WYBuilt 1992 · S/N 788N51723Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 1136N51735Styer David B · Milton Freewater, ORBuilt 1978 · S/N 1139N51739Quality Aero LLC · East Aurora, NYS/N 1141N51757Spencer John S · Indian, AKBuilt 1978 · S/N 423N51758Enstrom Instruction LLC · Newark, DEBuilt 1978 · S/N 435N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51774Salaika Timothy A · Danbury, TXS/N 440N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2N518EGStyer David B · Pendleton, ORS/N 812N51PDBcww LLC · Bakersfield, CABuilt 1996 · S/N 806N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042N52PDAviation Endeavors LLC · Houston, TXBuilt 1996 · S/N 807N539HSharkey'S Helicopters Inc · West Lebanon, NHBuilt 1976 · S/N 334N53PCMckenney Bret K · Billings, MTS/N 2028N53SABorreson Anthony · Reno, NVBuilt 1977 · S/N 385N540EHEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 5264N542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N544HLrh Equipment LLC · Pendleton, ORS/N 335N549HBazemore Dennis A · Ingleside, TXBuilt 1976 · S/N 345N54FSCouch Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 5089N551EHEnstrom Helicopter Corp · Menominee, MIS/N 5267N552EHEnstrom Helicopter Corp · Menominee, MIS/N 5266N554HSouthworth Elizabeth A · Igo, CABuilt 1976 · S/N 1039N565XMackechnie Martin J · Palm Harbor, FLBuilt 1978 · S/N 1138N56874Styer David B · Pendleton, ORBuilt 1979 · S/N 467N5687PBrown Clifford J · Hoschton, GAS/N 1167N5688RLowell Darryl S · Anchorage, AKS/N 466-2N5688TJoe Koch Construction Inc · Youngstown, OHBuilt 1980 · S/N 480-2N5689NRobinson Ryan A · Burbank, CABuilt 1979 · S/N 468-2N5690BK & L Aerial LLC · Echo, ORBuilt 1979 · S/N 1171N5690DRolfe Cameron R · San Mateo, CABuilt 1978 · S/N 1154N5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 477N5690PMultiaero Corp · Brooklyn, NYS/N 475-2N5691MBrowning Robert F · Washington, DCBuilt 1980 · S/N 485-2N56926Bitwell Construction LLC · Hartville, OHS/N 1188N5692YSilverado Sales Inc · Orem, UTBuilt 1980 · S/N 494-2N5693RWaters Willie Frank Jr · Willits, CAS/N 1194N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2N5694NBegley Edward · Glasgow, KYS/N 1197N5695AJacob Ricker · Ranchester, WYS/N 1201N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2N5697MStanton Mark I · Spokane, WAS/N 1209N5698ELrh Equipment LLC · Pendleton, ORS/N 506-2
Back to AD 2012-11-05