N612AE
Service difficulty reports · 208
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N612AE' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N612AE' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SIMA200933801Wire Harness · looseDURING FLIGHT 3802 ON LANDING GEAR EXTENSION THE CREW REPORTED, RECEIVED EICAS LANDING AIR GROUND FAIL MESSAGE. THE MESSAGE REMAINED ON UNTIL THE GEAR WAS RETRACTED AND DID NOT RE-APPEAR AFTER SECOND LANDING GEAR EXTENSION. THE CREW DECLARED AN EMERGENCY ANDSDR SIMA200932706Floor Support · corrodedDURING MAINTENANCE BASE INSPECTION FOUND THE CENTER OMEGA BEAM CORRODED AND CRACKED AT FRAME 25. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED OMEGA BEAM AT FRAME 25 WITH DOUBLER REPAIR IAW EMBRAER SRM 53-00-10 STEP 4. THE AIRCRAFT WAS RETURNED TO SERVICESDR SIMA200914503SUPEngine · leakingON FLIGHT 3987, DURING ROTATION DETECTED ELECTRICAL SMOKE THEN AT 500 FEET CREW RECEIVED A LAV SMOKE WARN. ODOR LINGERED UNTIL CREW WAS BACK AT THE GATE. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED LEFT ENGINE. DEFECTS NOTED. OPS CHECK GOOD. AIRCSDR SIMA200914503Engine · odorON FLIGHT 3987, DURING ROTATION SMELLED ELECTRICAL SMOKE THEN AT 500 FEET CREW RECEIVED A LAV SMOKE WARN. ODOR LINGERED UNTIL CREW WAS BACK AT THE GATE. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED LEFT ENGINE. DEFECTS NOTED. OPS CHECK GOOD. AIRCRSDR SIMA200908502Duct · meltedON FLIGHT 9800 CREW REPORTED ON CRUISE A SLIGHT BURNING SMELL IN COCKPIT. SMELL WAS NOT NOTICED IN CABIN. CREW SELECTED A COOLER TEMP ON LEFT PACK SMELL DISSIPATED. SELECTED WARMER ON LEFT PACK SMELL RETURNED. TURNED LEFT PACK OFF SMELL WENT AWAY. KEPT PASDR SIMA200902002Windshield · crackedON FLIGHT 4475 CREW REPORTED CLIMBING THROUGH 15,000 FT, THE FO`S WINDSHIELD SHATTERED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED FO’S WINDSHIELD IAW EMB AMM 56-10-01. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200826604Unknown · odorON FLIGHT 3444 CREW REPORTED STRONG SMELL EMANATING FROM LAV. THEN LAV SMOKE INDICATION CAME ON. THE CAPT REPORTS IT WAS A STRANGE SMELL SHE HAS NOT SMELLED BEFORE. STATES SHE FELT LIKE SHE GOT HIGH FROM SMELL. IMMEDIATELY THEY DECLARED AN EMERGENCY AND TUSDR SIM2008F00006Hose · leakingCREW REPORTED LOSS OF ENGINE 1 HYDRAULIC PRESS AND FLUID AFTER EXTENDING MLG ON LANDING. HYDRAULIC 1, LOW QUT MESSAGE ILLUMINATED ON CLIMB OUT/ AFTER LANDING GEAR ENGINE 1 HYDRAULIC FAIL MSG ILLUMINATED. LOST NW STEERING HAD TO BE TOWED TO GATE. AIRCRAFT REMSDR SIMA200804302Switch · malfunctionedON FLIGHT 4025, CREW REPORTED AFTER THEY SELECTED GEAR DOWN. A LANDING GEAR/LEVER DISAGREE MESSAGE APPEARED. THE MESSAGE REMAINED DURING TRANSIT AND AFTER LOCKED INDICATION. MESSAGE EXTINGUISHED APPROXIMATELY 1-2 SECONDS AFTER IN TRANSIT LIGHTS WENT OUT ANDSDR SIMA200733707Engine · power lossCREW REPORTED DURING CRUISE AT FL360, NR 1 ENG EXPERIENCED A SUDDEN LOSS OF RPM BOTH N1 AND N2 INDICATIONS DROPPED APPROX 70 PERCENT N1, BUT AUTO RELIGHT OCCURRED WITHIN IN 3-5 SECONDS. REST OF THE FLIGHT NORMAL.SDR SIMA200729913Door Frame · gougedDURING A MBV INSPECTION, THE CARGO DOOR FORWARD FRAME WAS FOUND TO BE GOUGED. REMOVED GOUGED FRAME AND REPLACE WITH NEW FRAME PN 145-23775-601 IAW SRM CHAPTERS 51-10-03, 51-40-02, AND 51-40-04. AIRCRAFT RETURN TO SERVICE.SDR SIMA200729915Floor Support · corrodedDURING A MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 29 WAS FOUND TO BE CORRODED. REMOVED CORRODED AREA AND REPLACED AREA IAW SRM 53-00-10. AIRCRAFT RETURN TO SERVICE.SDR SIMA200729914Sill · corrodedDURING A MBV INSPECTION, THE CARGO DOOR CUT OUT LOWER SILL WAS FOUND TO BE CORRODED. REMOVED THE SILL AND REPLACED WITH A NEW SILL PN 145-25480-603 IAW EMBRAER SRM CHAPTERS 51-20-01, 51-20-03, 51-40-02,51-40-06, 51-40-09 AND EMBRAER CPM CHAPTERS 51-21-04, 51-SDR SIMA200727703Bushing · unknownUNUSUAL AIRFRAME VIBRATION IN FLIGHT ALONG THE LONGITUDINAL AXIS. REMOVED AND REPLACED RIGHT RAM AIR VALVE SHAFT BUSHINGS IAW EMB CMM 21-25-01. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200723503Battery Pack · failedEMERGENCY FLOOR LIGHTS BETWEEN ROW 8 AND 12 INOPERATIVE, FERRIED AIRCRAFT FROM BUF TO ORD. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IAW EMB AMM 33-50-04. OPERATIONAL CHECK GOOD, AIRCRAFT RETURNED TO SERVICE.SDR SIMA200617702Ballast · defectiveORD - FLT 3968 - FLIGHT CREW REPORTS ELECTRIC SMELL IN AFT PASSENGER CABIN. REPLACED TWO CEILING LIGHT BALLAST. OPS CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200615901Switch · faultyL/G AIR GROUND FAIL EICAS MSG GEAR WOULD NOT RETRACT. REPLACED TWO WOW SWITCHES ON THE RIGHT MLG AND ONE WOW SWITCH ON THE LT MLG. PASSED FCF. RT MLG NR 1 WOW P/N 852701 S/N A7619. RT MLG NR 2 WOW P/N 8005701 S/N 1276. LT MLG NR 2 P/N 852701 S/N 8224. OPSDR SIMA200616401Control Unit · malfunctionedMSN - FLT 3953 - AFTER TAKEOFF, LANDING GEAR WOULD NOT RETRACT FOLLOWED AOM AND RETURNED TO MSN. RAI LGEU. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200615307Ecu · faultyFOUND LANDING GEAR WOULD NOT RETRACT. RAI LANDING GEAR ELECTRONIC UNIT. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200529701Floor Support · corrodedTHE LEFT OMEGA BEAM AT FRAME 25 WAS FOUND CORRODED. PERFORMED A CUTOUT OF THE OMEGA BEAM TO REMOVE THE CORROSION. FABRICATED A FILLER, DOUBLER AND SHIMS. REPAIR DONE IAW EMB 145 SRM, SRM EMB-145/1142 REV 30, CHAPTER 53-00-10, FIG 201. (M)SDR SIMA200529704Sill · corrodedABI - THE SERVICE DOOR CENTER SILL WAS FOUND TO BE CORRODED. REMOVED THE CORRODED SERVICE DOOR CENTER SILL. INSTALLED SERVICEABLE SILL IAW EMB SRM, SRM 145/1142 REV 31, CHAPTER 51-40-02. (M)SDR SIMA200529702Floor Support · corrodedA PREVIOUS REPAIR ON THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND CORRODED. REMOVED THE EXISTING REPAIR AND CLEANED THE AREA. FABRIATED A FILLER, DOUBLER, PLATE AND SHIMS. REPAIR DONE IAW EMB 145 SRM, SRM EMB-145/1142 REV 31, CHAPTER 53-00-10, FIG 201. (M)SDR SIMA200529306Floor Support · corrodedTHE GALLEY CENTER BEAM WAS FOUND CORRODED. REMOVED DAMAGED BEAM AND INSTALLED SERVICEABLE BEAM. REPAIR DONE IAW EMB 145 SRM, SRM EMB145/1142 REV 31, CHAPTERS 51-40-02 AND 51-20-03. (M)SDR SIMA200522007Wire · failedAMA - FLT 3779 - ON LANDING, CREW RECEIVED DUAL PITCH TRIM FAILURE 50 FT ABOVE GROUND. FOUND NR 2 AUTOPILOT DISCONNECT TRIM SWITCH WIRING CAUSED SWITCH TO BIND. REPOSITIONED WIRES AND SWITCH OPERATES CORRECTLY. ALL OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNESDR SIMA200520606Acm · seizedAFTER A NORMAL TAKEOFF AND CLIMB AT 9000 FT, CREW REPORTED SMOKE IN THE COCKPIT AND CABIN. SHORTLY BEFORE LANDING, CREW RECEIVED A PACK 1 OVERLOAD AND PACK 1 OVERHEAT EICAS MESSAGE. MAINTENANCE REPLACED NR 1 AIR CYCLE MACHINE OPERATIONAL CHECK GOOD. AC RETUSDR SIMA200509404Pressure Switch · defectiveIN CRUISE FLIGHT RUDDER SYSTEM HALF INOPERATIVE EICAS WARNING ILLUMINATED WENT OUT THEN REILLUMINATED. DECLARED EMERGENCY COMING INTO LGA AND LANDED WITHOUT INCIDENT. REPLACED RUDDER PRESSURE SWITCH IAW AMM 27-2304. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNESDR SIMA200412002Odor · detectedGSO - FLT 3625 - CREW REPORTED A MILD IRRITANT ODOR IN CABIN. SMELLS LIKE EUCALYPTUS OIL OR VICKS VAPOR RUB. MAINTENANCE COULD NOT DUPLICATE DISCREPANCY. GROUND RAN AIRCRAFT WITH CREW TO ISOLATE ANY ODORS. NO ODORS NOTED FROM EITHER PACK OR BLEED SYSTEM. SDR SIMA200409701Pressure Switch · malfunctionedRUDDER 1/2 INOP EICAS. FOLLOWED CHECKLIST, MECHNICAL CONTROL NORMAL. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED NR 2 RUDDER PRESSURE SWITCH IAW AMM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200304804Windshield · failedORD - FLT 4212 - DURING FLIGHT, THE CAPTAINS WINDSHIELD SHATTERED. AN EMERGENCY WAS DECLARED AND AIRCRAFT WAS LANDED WITH NO FURTHER INCIDENTS REPORTED. MAINTENANCE REMOVED AND REPLACED THE CAPTAINS WINDSHIELD IAW EMB MM. OPERATIONAL CHECK WAS GOOD AND AIRCSDR SIMA200212104Sill · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CARGO DOOR CUT OUT LOWER SILL CORRODED. REMOVED CORRODED SILL (BEAM). POSITIONED NEW BEAM AND INSTALLED. WORK DONE IAW EMB 145 (SRM 145/1142 CHAPTER 51, REV 17) 51-40-02, AND STANDARD SRM PRACTICES. (M)SDR SIMA200212101Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY CUT OUT. PERFORMED AN NDT INSPECTION OF THE AREA AND FOUND NO REJECTABLE INDICATIONS. FABRICATED A REPLACEMENT STRAP, TWO DOUBLERS AND A SHIM IAW EMB 145 (SDR SIMA200212103Doubler · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAF, FOUND CORROSION ON LEFT OMEGA BEAM (PREVIOUS REPAIR) AT FRAME 20. REMOVED PREVIOUS REPAIR, CORROSION LIMITED TO PREVIOUS REPAIR. FABRICATED A DOUBLER ANGLE, FILLER, A PLATE, AND TWO SHIMS. REPAIRED IAW EMB145 SRM1SDR SIMA200212102Sill · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON SERVICE DOOR CENTER SILL. REMOVED CORROSION BY BLENDING. FABRICATED A REPAIR DOUBLER. REPAIRED IAW EMB GST-1246/02, ITEM 4 AND STANDARD SRM PRACTICES. (M)SDR SIMA200212110Sill · corrodedABI - THIS IS A LEVEL 2 FINDING, CARGO DOOR CUT OUT LOWER SILL CORRODED. INSTALLED SERVICEABLE SILL IAW EMB 145 SRM 51-40-02. (M)SDR SIMA200212125Sill · corrodedABI - THIS IS A LEVEL 2 FINDING, SERVICE DOOR CENTER SILL CORRODED. REPAIRED IAW EMB145 GST-1246/02. (M)SDR SIMA200212124Sill · corrodedABI - THIS IS A LEVEL 2 FINDING, RIGHT CABIN SILL HAS CORROSION AT FRAME 38. REPAIRED IN IAW EMB 145 GST 1246/02. (M)SDR SIMA200212123Floor Support · corrodedABI - THIS IS A LEVEL 2 FINDING, LEFT BEAM GUSSET UNDER SEAT TRACK HAS CORROSION. REPAIRED IAW EMB GST-1284/02. (M)SDR SIMA200212122Floor Support · corrodedABI - THIS IS A LEVEL 2 FINDING, CENTER BEAM RAMP SUPPORT CORRODED. INSTALLED NEW CENTER BEAM IAW EMB145 SRM 51-40-02, 51-20-03. (M)SDR SIMA200212121Sill · corrodedABI - THIS IS A LEVEL 2 FINDING, RIGHT SILL CABIN HAS CORROSION BETWEEN FRAMES 24-30. INSTALLED NEW SILL IAW EMB145 SRM 51-40-02, 51-20-01. (M)SDR SIMA200212120Floor Support · corrodedABI - THIS IS A LEVEL 2 FINDING, CENTER BEAM GUSSET CORRODED. INSTALLED NEW GUSSET IAW EMB145 SRM 51-40-02, 51-40-06, 51-20-03. (M)SDR SIMA200212119Crossbeam · corrodedTHIS IS A LEVEL 2 FINDING, CROSS BEAM AT FRAME 23 CORRODED. INSTALLED NEW CROSSBEAM IAW EMB145 SRM 51-40-02, 51-20-01. (M)SDR SIMA200212118Support · corrodedABI - THIS IS A LEVEL 2 FINDING, PASSENGER DOOR FORWARD THRESHOLD SUPPORT CORRODED. INSTALLED NEW PASSENGER DOOR FORWARD THRESHOLD SUPPORT IAW EMB145 SRM 51-40-02, 51-20-01. (M)SDR SIMA200212117Support · corrodedABI - THIS IS A LEVEL 2 FINDING, PASSENGER DOOR AFT THRESHOLD SUPPORT CORRODED. INSTALLED NEW PASSENGER DOOR SUPPORT IAW EMB145 SRM 51-40-02, 51-20-01. (M)SDR SIMA200212116Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, PREVIOUS REPAIR AT LEFT OMEGA BEAM AT FRAME 20 IS CORRODED. REPAIR DONE IAW EMB145 SRM 53-21-10, FIG 201. (M)SDR SIMA200212115Gusset · corrodedABI - THIS IS A LEVEL 2 FINDING, AFT BEAM DIAMOND PLATE CORRODED. INSTALLED SERVICEABLE AFT DIAMOND IAW EMB145 SRM 51-40-02, 51-40-04, 51-40-06, 51-20-01, 51-20-03. (M)SDR SIMA200212114Sill · corrodedTHIS IS A LEVEL 2 FINDING, SERVICE DOOR AFT SILL CORRODED. INSTALLED NEW AFT SILL IAW EMB145 SRM 51-40-02, 51-40-04, 51-40-06. (M)SDR SIMA200212113Sill · corrodedABI - THIS IS A LEVEL 2 FINDING, SERVICE DOOR FORWARD SILL CORRODED. INSTALLED SERVICEABLE FORWARD SILL IAW EMB 145 SRM 51-40-02, 51-40-06, 51-20-03. (M)SDR SIMA200212112Gusset · corrodedABI - THIS A LEVEL 2 FINDING, RIGHT BEAM FORWARD DIAMOND PLATE CORRODED. INSTALLED NEW BEAM IAW EMB145 SRM 51-40-02, 51-20-03, 51-40-06. (M)SDR SIMA200212109Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY FORWARD DIGITAL CORRODED. REPAIRED GALLEY FORWARD DIGITAL IAW EMB145 SRM 53-21-10. (M)SDR SIMA200212139Frame · corrodedTHIS IS A LEVEL 2 FINDING, PROFILE CORRODED AT FRAME 23. INSTALLED NEW PROFILE IAW EMB 145 SRM 51-40-02, 51-20-01. (M)
Back to N612AE