N1334U, cancelled Aug 16, 2012
Service difficulty reports · 44
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 = 'N1334U' AND deregistration_id = 'N1334U-2012-08-16' 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 = 'N1334U' AND deregistration_id = 'N1334U-2012-08-16' 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 DALA100189933Battery Pack · inoperativeDURING LINE CHECK, MX FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 5-7 OF THE CABIN WERE INOPERATIVE. MX REPLACED THE BATTERIES IN THE POWER PACK. OPS CHECK WAS GOOD.SDR DALA100179933Sign · inoperativeDURING LINE CHECK, MX FOUND THAT THE RT OVERWING EMERGENCY EXIT SIGN WAS INOPERATIVE. MX REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR NWAA094119933Power Supply · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERWING EMERGENCY EXIT SIGNS ON BOTH SIDES OF THE AIRCRAFT WERE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT POWER SUPPLY AND OPERATIONALLY CHECKED THE SYSTEM.SDR 0400519933Splice · crackedDURING "M" CHECK FOUND CRACK IN LONGERON 30 SPLICE FITTING FROM BS 580 TO BS 604. REPAIRED PER EA 99-198614.SDR 0202489933Service difficultyDURING CLIMB, FLIGHT ATTENDANT NOTICED SMOKE IN CABIN AND FORWARD LAV ALARM SOUNDED. FLIGHT CREW RETURNED AIRCRAFT TO DEPARTURE AIRPORT AND PERFORMED AN UNEVENTFUL LANDING. MAINTENANCE FOUND AN APU OIL LEAK. OIL LEAK WAS CORRECTED, CLEANED APU AREA, AND COMPSDR 0103279933Skin · crackedDURING AN L-CHECK. THE LOWER AFT CORNER OF THE SERVICE DOOR SKIN WAS FOUND WITH CRACKS. THE SUBJECT SKIN PANEL WAS TRIMMED AND RESTORED USING A SPLICE AFT OF THE DOOR CUT OUT USING EA 99-169344 LOG PAGE 1577098. THE EXISTING SKIN ASSEMBLY 5911407-33 IS MANUFSDR 0100619933Pump · failedDURING FLIGHT AT FL350, THE RIGHT ENGINE CEASED OPERATING. THE FLIGHT CREW FOLLOWED COM PROCEDURES, DIVERTED TO CLE, AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE ENGINE DRIVEN FUEL PUMP LOCATED ON THE RIGHT ENGINE. OPERATIONAL CHECK NORMAL.SDR 9900199933Actuator · failedDURING APPROACH, CREW HEARD A LOUD THUD FROM THE NOSE GEAR AREA. FLAP/RUDDER STOP LIGHT ILLUMINATED, HYDRAULIC PRESSURE WAS BETWEEN 800 TO 1000 PSI, AND GEAR DOOR OPEN LIGHT ILLUMINATED. FLIGHT CREW DECLARED AN EMERGENCY AND THE AIRCRAFT LANDED WITHOUT INCIDSDR 9808299933Release Mech · out of adjustDURING TAIL CONE FUNCTION CHECK, FOUND THAT INADEQUATE FORCE WAS REQUIRED TO DEPLOY TAIL CONE USING THE INTERIOR HANDLE. RIGGED TAIL CONE DEPLOYMENT SYSTEM, FUNCTIONAL CHECK OK.SDR 9808769933Bulkhead · corrodedDURING M-CHECK, FOUND CORROSION ON LONGERON 29L AT FS 513. REPAIRED PER EA 99-154884.SDR 9806279933Fitting · crackedDURING M-CHECK, FOUND CRACK IN END FITTING FOR LONGERON 28L AT FS 589. REPLACED FITTING (P/N 5920332-1N) PER SRM 51-30-2.SDR 9806259933Fitting · corrodedDURING M-CHECK, FOUND CORROSION OF END FITTING FOR LONGERON 26L AT FS 589. REPLACED FITTING (P/N 3920334-1N) PER SRM 51-30-2.SDR 9808779933Bulkhead · crackedDURING M-CHECK, FOUND CRACK IN NOSE LANDING GEAR WHEEL WELL HORIZONTAL PRESSURE PANEL FS 110 AT THE LEFT OUTBOARD VERTICAL BEAM. REPAIRED PER EA 99-154798.SDR 9807449933Bulkhead Web · crackedDURING M CHECK, FOUND A CRACK IN THE WEB OF THE FS 37 BULKHEAD AS VIEWED THROUGH ACCESS HOLE ABOVE THE LEFT UPPER RADOME GUIDE PIN HOLE. REPAIRED PER EA 99-154843.SDR 9807439933Bulkhead Web · crackedDURING M CHECK, FOUND CRACK IN THE WEB OF FS 37 BULKHEAD AS VIEWED THROUGH THE ACCESS HOLE ABOVE THE RIGHT UPPER RADOME GUIDE PIN. REPAIRED PER EA 99-154843.SDR 9803259933Power Supply · inoperativeDURING LINE MAINTENANCE INSPECTION, FOUND AFT FLIGHT ATTENDANT, TAIL COMPARTMENT AND NACELLE EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY AND CHARGER TO B5-27 UNIT, OPERATIONAL CHECK NORMAL.SDR 9801819933Connectors · dirtyDURING LINE MAINTENANCE INSPECTION, FOUND THE RIGHT OVERWING EMERGENCY EXIT AND AFT AIRSTAIR EMERGENCY LIGHTS INOPERATIVE. CLEANED CONNECTION IN AIRSTAIR LAMP AND TIGHTENED GROUND LUG ON LIGHT ASSEMBLY AT FORWARD RIGHT OVERWING EXIT SIGN. OPERATIONAL CHECK NSDR 9800139933Strut · underservicedAIRCRAFT FAILED TO SHIFT FROM GROUND MODE TO FLIGHT MODE AFTER TAKEOFF. FLIGHT WAS RETURNED TO MSP AND LANDED WITHOUT INCIDENT. MAINTENANCE SERVICED NOSE GEAR STRUT TO PROPER LEVELS. OPERATIONAL CHECK NORMAL ON GEAR CYCLE.SDR 9720739933Light · shortedRIGHT MAIN LANDING GEAR GREEN LIGHT REMAINED ON AFTER GEAR RETRACTION. FLIGHT WAS RETURNED TO MSP AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND RIGHT MAIN GEAR GREEN INDICATION LIGHT SHORTING OUT. REPLACED LIGHT ASSEMBLY, OPERATIONAL CHECK NORMAL.SDR 9719529933Wire · brokenDURING LINE MAINTENANCE INSPECTION, FOUND ROWS 11, 12 AND 13 AISLE EMERGENCY LIGHTS WOULD NOT SHUT OFF. WIRES TO SEAT TRACK WERE FOUND TO BE CHAFED. REPAIRED WIRE AND REPOSITIONED INSIDE RACEWAY, OPERATIONAL CHECK NORMAL.SDR 9719139933Battery Pack · dischargedFLIGHT ATTENDANT REPORTED EMERGENCY PATH LIGHTS REMAINING ON AT EMERGENCY ROWS DURING FLIGHT. MAINTENANCE REPLACED BOTH LEFT OVERWING EMERGENCY BATTERY PACKS, OPERATIONAL CHECK NORMAL.SDR 9718559933Batteries · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND AFT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERIES IN MID OVERHEAD SECTION FOR OVERWING DOORS. OPERATIONAL CHECK NORMAL.SDR 9713879933Battery Pack · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND TAIL COMPARTMENT AND NACELLE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACKS, OPERATIONAL CHECK NORMAL.SDR 9711889933Battery Pack · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND RIGHT FORWARD OVERWING EMERGENCY EXIT SIGN VERY DIM. REPLACED BATTERY PACK, OPERATIONAL CHECK NORMAL.SDR 9712859933Battery · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD LEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY, OPERATIONAL CHECK NORMAL.SDR 9710859933Battery · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD LEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY. OPERATIONAL CHECK NORMAL.SDR 9710099933T-Ducts · lack of lubeDURING APPROACH, SLAT DISAGREEMENT LIGHT ILLUMINATED AND AIRCRAFT ROLLED SLIGHTLY TO THE RIGHT ON SLAT EXTENSION. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED PADS ON RIGHT TELESCOPE DUCT AND LUBED LEFT DUCT, OPERATIONAL CHECK NORMAL.SDR 9708799933Radar · failedWEATHER RADAR SYSTEM FAILED DURING CLIMBOUT. FLIGHT RETURNED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE COULD NOT DUPLICATE DISCREPANCY ON GROUND. REPLACED RADAR TRANSCEIVER AND INDICATOR AS A PRECAUTION, OPERATIONAL CHECK NORMAL.SDR 9706119933Link · brokenA LOUD VIBRAITON WAS COMING FROM NOSE GEAR AREA AFTER TAKEOFF. FLIGHT RETURNED TO MSP AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED BROKEN NOSE GEAR DOOR LINK AND CABLE, OPERATIONAL CHECK NORMAL.SDR 9702179933Switch · malfunctionedDURING APPROACH INTO DTW, ALL THREE RED UNSAFE LIGHTS REMAINED ON AFTER GEAR EXTENSION. RECYCLED GEAR AND NORMAL INDICATIONS WERE ACHIEVED. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED LANDING GEAR LEVER WARNING SWITCH S1-89. OPERATIONAL CHECK NSDR 9700079933Retract Mech · out of adjustON DESCENT, THE NOSE GEAR GREEN LIGHT FAILED TO ILLUMINATE ON GEAR EXTENSION. ACCOMPLISHED COCKPIT OPERATING MANUAL PROCEDURE AFTER GEAR RETRACTION. GEAR LIGHTS NORMAL ON SECOND EXTENSION. NOSE GEAR OVERCENTER LINKAGE WAS RESHIMMED AND ADJUSTED. PERFORMED SDR 9627239933Downlock · malfunctionedDURING APPROACH, NOSE LANDING GEAR GREEN LIGHT DID NOT ILLUMINATE AFTER GEAR EXTENSION. RED UNSAFE LIGHT WAS OUT. RECYCLED GEAR AND NORMAL INDICATIONS WERE ACHIEVED. FLIGHT DIVERTED TO CLT AND LANDED WITHOUT INCIDENT. MAINTENANCE REPAIRED BROKEN WIRE G200LSDR 9626489933Lock Switch · frozenDURING APPROACH, NOSE LANDING GEAR GREEN LIGHT DID NOT ILLUMINATE AFTER GEAR EXTENSION. RECYCLED GEAR AND NORMAL INDICATIONS WERE ACHIEVED. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NOSE GEAR LOCK SWITCH COVERED WITH ICE. CLEANED LOCK SWITCH, OPESDR 9624999933Switch · out of adjustDURING APPROACH, NOSE LANDING GEAR GREEN LIGHT DID NOT ILLUMINATE AFTER GEAR EXTENSION. RECYCLED GEAR AND NORMAL INDICATIONS WERE ACHIEVED. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE ADJUSTED NOSE GEAR LOCK SWITCH ACTUATING BOLT. OPERATIONAL CHECK NORMASDR 9620409933Web · crackedDURING H-CHECK, FOUND A 6 INCH CRACK IN THE HORIZONTAL PRESSURE PANEL AT FS 83 AT THE LEFT VERTICAL FRAME ATTACH POINT. REPAIRED THE PANEL (P/N 9910073-3) PER EA 99-111213.SDR 9619639933Blkhd Fitting · crackedDURING H-CHECK, FOUND A CRACK IN THE LEFT KEEL TO BULKHEAD ATTACH FITTING FS 756. REPLACED FITTING (P/N 3915135-505N) PER SRM 51-30.SDR 9619619933Fitting · crackedDURING H-CHECK, FOUND A CRACK IN THE AFT CARGO DOOR LOWER BEAM FORWARD END FITTING. REPLACED FITTING.SDR 9619319933Bulkhead Fitting · crackedDURING H-CHECK, FOUND A CRACK IN THE FORWARD CARGO COMPARTMENT AFT BULKHEAD FITTING AT LONGERON 24L. REPLACED FITTING PER SRM 51-30-2, 51-30-5.SDR 9618789933Pulley Bracket · failedSLAT DISAGREEMENT LIGHT ILLUMINATED WITH ASYMMETRIC SLATS ON APPROACH. THERE WAS NO BLUE SLAT EXTEND LIGHT. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND LEFT INBOARD SLAT DRIVE NR 1 PULLEY, CABLE AND BRACKET PULLED FROM FORWARD SPAR. REPLACED PULLEYSDR 9610549933Linkage · lack of lubeLEFT THROTTLE WAS STICKING WHEN POWER WAS PULLED BACK AT TOP OF CLIMB. FLIGHT RETURNED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE CLEANED AND LUBED PUSH/PULL LINKAGE ON LEFT ENGINE, OPERATIONAL CHECK NORMAL.SDR 9607809933Wire · brokenDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD CABIN FLOOR PROXIMITY EMERGENCY LIGHTS INOPERATIVE. REPLACED BROKEN WIRING AT ROW 1, OPERATIONAL CHECK NORMAL.SDR 9605849933Anti Ice Duct · bindingSLAT DISAGREEMENT LIGHT ILLUMINATED WITH NOTICEABLE ROLL TO THE RIGHT WHEN SLATS WERE EXTENDED FOR LANDING INTO DTW. CYCLED SLATS WITH SAME RESULTS. SUCCESSFUL LANDING WAS ACCOMPLISHED USING FLAPS ONLY. NOTE: BLUE SLAT EXTEND LIGHT NEVER ILLUMINATED. MAINTSDR 9603089933Retract Mech · lack of lubeON APPROACH, SLAT DISAGREEMENT LIGHT ILLUMINATED AND ROLL WAS EXPERIENCED. A SUCCESSFUL LANDING WAS ACCOMPLISHED WITH SPLIT FLAP/SLAT HANDLE. CHECKED SLAT RIGGING AND RETRACT/EXTEND SWITCHES, ALL CHECKED GOOD. LUBED ANTI-ICE TELESCOPING DUCTS.SDR 9601029933Strut · reqd serviceDURING CLIMB, THE NOSE LANDING GEAR WOULD NOT RETRACT AND THE AIRCRAFT DID NOT SHIFT INTO FLIGHT MODE. AIRCRAFT RETURNED TO YUL AND LANDED WITHOUT INCIDENT. SERVICED NOSE LANDING GEAR STRUT AND OPERATIONAL CHECK GOOD.
Back to N1334U, cancelled Aug 16, 2012