N13936, cancelled Jan 9, 2017
Service difficulty reports · 95
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 = 'N13936' AND deregistration_id = 'N13936-2017-01-09' 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 = 'N13936' AND deregistration_id = 'N13936-2017-01-09' 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 ASOA20140628163Frame · crackedDURING C-CHECK, FRAME 10R CRACKED UNDER DV WINDOW. R & R FRAME IAW SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20140624135VHinge Fitting · wornDURING C-CHECK THE TOP MOUNTING HINGE ON THE VERTICAL STABILIZER FOR RUDDER, FOUND TO BE WORN. MAINTENANCE R & R THE HINGE IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121201152Skin · crackedDURING A-CHECK INSPECTION, TWO CRACKS WERE FOUND IN THE FUSELAGE SKIN EMINATING FROM THE SAME RIVET AT FRAME 75, STRINGER 2R. MX PERFORMED A DOUBLER REPAIR AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20120417059Door Frame · corrodedCORROSION ON LWR AFT FRAME STRUCTURE OF SERVICE DOOR FRAME 22. CUT OUT DAMAGED AREA, DRILLED AND INSTALLED REPAIR DOUBLER.SDR C2XA11IA170Engine · leakingIAH - FLIGHT 2448, THE CREW REPORTED THAT THE CREW AND CUSTOMERS WERE COMPLAINING OF AN UNPLEASANT SMELL FROM THE PACK SYSTEM. THE AIRCRAFT LANDED AT IAH WITHOUT INCIDENT WHERE MAINTENANCE REMOVED AND REPLACED THE NUMBER TWO ENGINE, OPERATIONALLY TESTED WITH SDR C2XA10IA195Battery · overtempIAH - DURING PREFLIGHT INSPECTION THE CREW REPORTED A BATT TWO OVERTEMP INDICATION APPROXIMATELY TWO MINUTES AFTER POWER UP WITH THE GPU SELECTED. BATTERY 2 INDICATED 71DEG AND WAS CLIMBING. MAINTENANCE REMOVED AND REPLACED THE NUMBER TWO MAIN BATTERY, OPERASDR C2XA10IA082Unknown · odorIAH - FLIGHT 2949, DURING PRE-FLIGHT INSPECTION THE CREW REPORTED A BURNING SMELL IN THE GALLEY. THE AIRCRAFT WAS INSPECTED AND THE COFFEE BREWERS PLACED ON NEF, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. THE AIRCRAFT RON'D AT SHV ON 02/25/08 WHERESDR C2XA09TY258Inlet · corrodedNR 1 AND NR 2 ENGINE INLETS HAVE CORROSION IN THE BOLT HOLES. REMOVED CORROSION IAW EC5420-01158.SDR C2XA09TY256Sill · corrodedRIGHT FLOORBOARD SILL HAS CORROSION FROM FRM 22 TO FRM 39. REMOVED AND REPLACED FLOOR SILLS IAW EMB SRM 51-40-02, 51-20-03.SDR C2XA09TY255Skin · crackedLEFT WINDSHIELD POST SKIN CRACKED. CUT AND REMOVED AREA OF CRACKED SKIN. FABRICATED AND INSTALLED FILLER AND DOUBLER IAW EC5310-01483.SDR C2XA09TY254Fitting · crackedLEFT ENGINE FORWARD YOKE LOWER LINKAGE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW EC 5450-01028.SDR C2XA09IA156Windshield · crackedIAH - FLIGHT 2809, THE CREW REPORTED THAT THE F/O'S WINDSHIELD CRACKED ON CLIMB. THE AIRCRAFT RETURNED TO IAH WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE F/O'S WINDSHIELD, OPERATIONALLY & LEAK CHECKED WITH NO DEFECTS, AND THE AIRCRSDR C2XA09IA107Hydraulic Line · leakingIAH - FLIGHT 2435, ON LANDING THE CREW REPORTED A LANDING GEAR LEVER DISAGREE WITH A NUMBER ONE HYDRAULIC QTY LOW AND NO NOSE STEERING. THE AIRCRAFT WAS TOWED TO THE GATE WHERE MAINTENANCE REMOVED AND REPLACED THE PRESSURE LINE ON THE NUMBER ONE MOTOR DRIVEN SDR C2XA09IA062Light · inoperativeIAH - DURING A-CK INSPECTION NUMEROUS EMERGENCY EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LEFT WING/FUSELAGE FRONT EMERGENCY LIGHT ASSEMBLY, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TOSDR C2XA09IA030Unknown · odorIAH - FLIGHT 2812, THE CREW REPORTED A FUEL SMELL COMING FROM THE APU BLEED. MAINTENANCE INSPECTED THE AIRCRAFT. VERIFIED NORMAL OPERATION OF APU BLEED WITH NO SMELL NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA08IA245Inverter · inoperativeIAH - FLIGHT 2524, DURING PREFLIGHT INSPECTION THE CREW REPORTED THE 2ND AND 3RD AISLE PATH LIGHT STRIP WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 3 INVERTER, OPERATIONALLY CHECKED WITH NO DEFECTS. THE AIRCRAFT WAS APPROVED FOR RETUSDR C2X2008F00043Wire Harness · burnedDURING PREFLIGHT INSP THE CREW REPORTED A SMOKE ODOR COMING FROM SEATS 3 & 4A. THE ACFT WAS RELEASED ON MEL 33-20-00 CAT C CTL NR 153947. THE AC LANDED, WHERE MAINT REMOVED AND REPLACED THE LIGHT SOCKET HARNESS ASSY AT ROW 4A, OPERATIONALLY CHECKED WITH NO DEFSDR C2XA08IA159Connector · overheatedTUL - FLIGHT 2845, THE CREW REPORTED SMOKE AND A SMELL OF FIRE AT SEAT 18A DURING DESCENT. THE AIRCRAFT LANDED AT TUL WITHOUT INCIDENT WHERE MAINTENANCE MEL`D THE PSU FOR SEAT 18A, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. THE AIRCRAFT CONTINUED TSDR C2XA07IA226Inverter · inoperativeIAH - FLIGHT 2828, THE CREW REPORTED THAT THE FORWARD EMERGENCY LIGHT WAS OUT. MAINTENANCE REMOVED AND REPLACED THE NUMBER FOUR EMERGENCY LIGHT INVERTER, OPERATIONALLY CHECKED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA07IA191Light · malfunctionedICT - FLIGHT 2914, THE CREW REPORTED THAT THE EMERGENCY LIGHTS WERE INOP FROM THE FLIGHT ATTENDANT POSITION. MAINTENANCE RESET THE EMERGENCY LIGHT SYSTEM, OPERATIONALLY CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA07IA177Sign · malfunctionedIAH - FLIGHT 2760, DURING PREFLIGHT INSPECTION THE CREW REPORTED AN EMERGENCY LIGHT SIGN AS BEING INOPERATIVE. MAINTENANCE INSPECTED THE AIRCRAFT, OPERATIONALLY CHECKED THE EMERGENCY LIGHTS WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SESDR C2XA07IA138Carbon Seal · wornIAH - FLIGHT 2902, DURING CLIMB THE CREW REPORTED SMOKE IN THE COCKPIT AND CABIN. THE AIRCRAFT RETURNED TO IAH WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE NUMBER ONE ENGINE, OPERATIONALLY CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WSDR C2XA07SH027Floor Support · corrodedSHV - DURING C-CHECK LEFT OMEGA BEAM HAS CORROSION AT FR 20. MX REPAIRED CORRODED AREA AT FR 20 LEFT OMEGA BEAM IAW EMB 145 SRM 53-00-10. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR C2XA07SH024Bushing · wornSHV - DURING C-CHECK RIGHT SPHERICAL BEARING FITTING ON VERTICAL STAB HINGE POINT IS WORN BEYOND TOLERANCE. MX REPAIRED RIGHT SPHERICAL BEARING FITTING ON VERTICAL STAB HINGE POINT BY REAMING TO 2ND REWORK AND INSTALLING OVERSIZE BUSHING IAW EMB 145 SRM 55-30SDR C2XA07IA032Bulb · burned outIAH - DURING PREFLIGHT INSPECTION, THE EMERGENCY EXIT LIGHT AT THE CABIN DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT BULB, OPERATIONALLY CHECKED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA07IA028Connector · inoperativeDURING MAINTENANCE INSPECTION THE GALLEY EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE CONNECTOR, OPERATIONALLY CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA06BT022Light · faultyEMERGENCY EXIT LIGHT STRIP BETWEEN ROWS 10 AND 12 ARE NOT WORKING. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT STRIP BETWEEN ROWS 10 AND 12 IAW EMB145 AMM 33-50-08. OPS CHECKED GOOD.SDR C2XA05RI014Sign · inoperativeRIC - DURING ROUTINE INSPECTION, EXIT ROW SIGN IN FRONT OF SEAT 3BC WAS FOUND INOP. MAINTENANCE CHECK THE BULBS AND CLEANED THE CONTACTS. OPERATIONAL TEST WAS PERFORMED SUCCESSFULLY. ACFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA05RI012Fuel Filter · cloggedE1 FUEL IMPENDING BYPASS MESSAGE ILLUMINATED IN FLIGHT. CREW DIVERTED FLIGHT. MX REMOVED AND REPLACED ENGINE 1 FUEL FILTER. OPERATIONAL TEST WAS SUCCESSFULLY PERFORMED. ACFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA05IA044Battery Pack · dischargedIAH - FLIGHT 2057 DURING PREFLIGHT INSPECTION THE CREW REPORTED THAT THE EXIT SIGNS OVER THE GALLEY, ROW 2B, AND THE FLT ATTENDANTS SEAT WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY CHECKESDR C2XA05IA039Battery Pack · dischargedIAH - FLIGHT 2057, DURING PREFLIGHT INSPECTION, THE CREW REPORTED SEVERAL EMERGENCY LIGHTS TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER ONE EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOSDR C2XA05IA038Battery Pack · dischargedIAH - FLIGHT 2057, DURING PREFLIGHT INSPECTION, THE CREW REPORTED THAT SEVERAL EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER THREE EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY CHECKED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROSDR C2XA05TY016Skin · corrodedTYS, DURING A SCHEDULED INSPECTION THE FUSELAGE SKIN INSIDE SURFACE AT THE POTABLE WATER MANIFOLD MOUNT, CORRODED. REMOVED THE CORROSION, ALODINED, FABRICATED NEW REPAIR DOUBLER AND INSTALLED, PAINTED AND PRESSURE CHECKED I/A/W-EC5330-01435.SDR C2XA05TY014Skin · crackedTYS, DURING A SCHEDULED INSPECTION, THE FUSELAGE SKIN WAS FOUND CRACKED AT FS 75. MAINTENANCE MEASURED DAMAGED AREA, CUT OUT, FABRICATED A DOUBLER AND INSTALLED I/A/W-EC5310-01320 AND IC2005-145/0271.SDR C2XAO5TY006Floor Support · corrodedTYS - DURING A SCHEDULED 4C INSPECTION, THE LT OMEGA BEAM BETWEEN FS 22 AND FS 23 HAS A BLENDED AREA BELOW LIMITS NEXT TO A NUTPLATE. MAINT CUTOUT THE EFFECTED AREA, FAB`D A SPLICE REPAIR FROM A NEW PART AND FAB`D AN INTERNAL ANGLE, DRILL, ALODINED, PRIMED ANSDR C2XA04IA165Light · inoperativeIAH - FLIGHT 2474, DURING PREFLIGHT INSPECTION, THE CREW REPORTED THAT THE ROW THREE EMERGENCY EXIT LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT, OPERATIONALLY CHECKED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SSDR C2XA04IA088Light · inoperativeDURING PREFLIGHT INSPECTION THE CREW FOUND THE EMERGENCY LIGHT STRIP AT ROW 9 TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT STRIP, OPERATIONALLY TESTED THE LIGHTING AND CLEARED THE DISCREPANCY.SDR C2XA04BT070Bulb · burned outCREW REPORTED, STRONG ODOR OF BURNED ELECTRICAL COMPONENTS IN CABIN ROW 7 AREA. MAINTENANCE REMOVED AND REPLACED SIDEWALL LIGHT ASSEMBLY AT ROW 5 AND 6 AREA IAW EMB 145 MM 33-21-06, OPS CHECKED LIGHTS GOOD.SDR C2XA04BT057Socket · damagedBTV-CO2248, DURING 4A INSPECTION, MAINTENANCE FOUND THE LEFTHAND OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP SOCKET ASSEMBLY. OPS CHECKED EMERGENCY LIGHTS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR C2XA04CL020Inverter · inoperativeCLE FLIGHT 2193 THE CREW REPORTED THE FORWARD EMERGENCY EXIT SIGN WAS INOPERATIVE. MAINTENANCE INSPECTED AND REPLACED THE NR 1 INVERTER. OPERATIONAL CHECKS WERE GOOD.SDR C2XA04CL019Connector · dirtyCLE FLIGHT 3451 THE CREW REPORTED THE EMERGENCY LIGHT SIGN AT 3BC WAS INOPERATIVE. MAINTENANCE INSPECTED AND CLEANED CONNECTORS ON THE EMERGENCY EXIT SIGN AT SEAT 3BC. OPERATIONAL CHECKS WERE GOOD.SDR C2XA04CL014Connector · looseFLIGHT NR 2103 THE CREW REPORTED THE EMERGENCY LIGHT AT ROW 3BC WAS INOPERATIVE. MAINTENANCE INSPECTED AND RESECURED LOOSE CONNECTOR ON THE EXIT SIGN. OPERATIONAL CHECKS WERE GOOD.SDR C2XA03IA117Uplock · inoperativeIAH FLIGHT 2072, PILOT REPORTED THAT THE LEFT MAIN LANDING GEAR DID NOT RETRACT. THE AIRCRAFT RETURNED TO IAH AND LANDED WITHOUT INCIDENT WHERE MAINTENANCE REMOVED AND REPLACED THE LEFT MAIN GEAR UPLOCK BOX. THE LANDING GEAR EXTENSION/RETRACTION SYSTEM WAS OSDR C2XA03CL147Housing · inoperativeDURING ROUTINE MAINTENANCE THE NR 1 EMERGENCY LIGHT WAS INOPERATIVE ON WING TO FUSELAGE PANEL. MAINTENANCE REPLACED THE NR 1 EMERGENCY LIGHT HOUSING ASSEMBLY IAW 33-51-10.OPERATIONAL CHECKS WERE GOOD.SDR C2XA03BT072Selector · dirtyCREW REPORTED, LANDING GEAR WARNING ON LANDING WITH LANDING GEAR DOWN AND THREE GREEN LIGHTS. MAINTENANCE CLEANED LANDING GEAR HANDLE CANNON PLUG, OPS CHECKED SYSTEM GOOD IAW EMB145 MM 32-32-00. AIRCRAFT RELEASED FOR SERVICE.SDR C2XA03CL120Sign · inoperativeCLE FLIGHT 2327, THE CREW REPORTED THE EMERGENCY LIGHTS ABOVE 3B WOULD NOT COME ON. MAINTENANCE REPLACED THE EMERGENCY EXIT LOCATOR SIGN. OPERATIONAL CHECKS WERE GOOD.SDR C2XA03CL099Light · inoperativeCLE FLIGHT 2268 THE CREW REPORTED EMERGENCY EXIT LIGHT WAS INOPERATIVE ON THE RIGHT SIDE BULKHEAD IN THE CABIN. MAINTENANCE INSPECTED AND PERFORMED OPERATIONAL CHECKS.NO DEFECTS WERE FOUND.THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR C2XA03SH033Stop · crackedSHV- DURING C-CHECK THE FOWARD EXTERNAL FRAME ON CARGO DOOR WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FRAME IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA03SH032Bracket · crackedSHV-DURING C CHECK THE BRACKET SUPPORTING THE ELEVATOR PULLEYS WAS FOUND CRACKED AND DEFORMED LOCATED IN VERTICAL STABILIZER BY PANEL 325LR. MAINTENANCE REMOVED AND REPLACED AFFECTED BRACKET IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APROVED TO RETURN TO SERSDR C2XA03SH030Floorbeam · crackedSHV- DURING C-CHECK A RAMP ANGLE WAS FOUND CRACKED ON LEFT HAND FLOORBEAM FOWARD OF FRAME 20. MAINTENANCE REMOVED DAMAGE AND PERFORMED AND ANGLE REPAIR IAW EMB SRM 51-30-01. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.
Back to N13936, cancelled Jan 9, 2017