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.

N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N56DKDeka Research & Development Corp · Manchester, NHBuilt 2009 · S/N 5127N571QXSouth County Helicopter LLC · Pilot Rock, ORBuilt 2005 · S/N 5080N572HCordrey Kenneth R · Delmar, DEBuilt 1976 · S/N 356N587KEEnstrom Helicopter Corp · Menominee, MIS/N 5268N58FSClark Mitchell P R · Drewsey, ORS/N 2108N594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeBuilt 1977 · S/N 1074N595ARMiddle Fork Aviation LLC · Meadowview, VAS/N 1182N59AXCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1982 · S/N 1227N59FSRegistration Pending · Yazoo City, MSRegistration pendingBuilt 2005 · S/N 2109N602HKing John H · Trumansburg, NYBuilt 1977 · S/N 1077N60AZGoldleaf Leasing LLC · Madison, WIBuilt 2007 · S/N 5106N613AHEnstrom Helicopter Corp · Menominee, MIS/N 2180N61GGCoggin Randall · Longview, TXS/N 1178N624CECertified Equipment Inspections LLC · Washington, PAS/N 462N624HNeed For Speed Inc · Dover, DEBuilt 1977 · S/N 1078N62VATiger 17 LLC · Wilmington, DEBuilt 1997 · S/N 2081N631DPHeritage Rotors LLC · De Leon Springs, FLBuilt 1980 · S/N 492-2N643HHagglund Caleb J · Pendleton, ORS/N 396N646HStyer David B · Milton Freewater, ORBuilt 1977 · S/N 1099N652MTThomas Michael W · Prescott, WABuilt 1989 · S/N 2043N656XMackechnie Martin J · Palm Harbor, FLS/N 784N663DSButler Raymond · Port Lavaca, TXBuilt 1991 · S/N 2065N665HHouchin Thomas J · Pittsburgh, PABuilt 1977 · S/N 1093N666CFTrofimchuck Matthew P · Coal City, ILBuilt 1977 · S/N 1069N666MDLrh Equipment LLC · Pendleton, ORS/N 338N668ZEEnstrom Helicopter Corp · Menominee, MIS/N 2181N669CEOne Pft LLC · Denton, MTBuilt 1992 · S/N 787N68LFLarsen Richard · Rexburg, IDBuilt 2007 · S/N 5114N698MBravo Zulu International Ltd · Las Vegas, NVBuilt 1982 · S/N 1509N6ENEnstrom Helicopter Corp · Menominee, MIBuilt 2024 · S/N 5258N700ATMoore Stirling · Douglas, WYS/N 1193N704DFrancis Greg · Texarkana, TXBuilt 1988 · S/N 2025N70719Emerson Frayne · Stanfield, ORS/N 1072N713CHHopkins David Martin · Bell Buckle, TNS/N 2037N726RMEaves Christopher C · Salt Lake City, UTBuilt 1997 · S/N 810N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048N728DBStyer David B · Pendleton, ORBuilt 1993 · S/N 332N730HLrh Equipment LLC · Pendleton, ORS/N 730N753BFAis Construction Equipment · Grand Rapids, MIBuilt 2006 · S/N 5090N755BFFulghum Matthew R · Woodside, CABuilt 2005 · S/N 2106N756HStyer David B · Milton Freewater, ORS/N 756N761DAKing Air 76 LLC · Lewes, DEBuilt 1990 · S/N 2059N762ALrh Equipment LLC · Pendleton, ORBuilt 1989 · S/N 762N776HCCyclic Aviation LLC · Millbrook, NYBuilt 2007 · S/N 2127N77HXAppold Dave J · Bay City, MIBuilt 1979 · S/N 4702
Back to AD 2012-11-05