N69735, cancelled Jul 29, 2011
Service difficulty reports · 78
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 = 'N69735' AND deregistration_id = 'N69735-2011-07-29' 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 = 'N69735' AND deregistration_id = 'N69735-2011-07-29' 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 CALA9801304Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORROSION AT STA 328, LBL 30 AND 45, STA 344, STA 380, RBL 32 TO 42. THE CORRODED AREAS OF FLOORBEAM WERE CUT OUT. REPAIRS WERE FABRICATED AND INSTALLED IAW SRM 53-10-8, 51-10-2, AND 51-40-4.SDR CALA9801303Door · crackedINSPECTION FOUND A 1.5 INCH CRACK IN AFT CARGO C-2 DOOR BOTTOM AFT CORNER. THE CORNER OF C-2 DOOR WAS REMOVED AND REPLACED IAW SRM 51-10-2.SDR CALA9801198Rib · crackedINSPECTION FOUND A .375 INCH CRACK IN UPPER OUTBOARD FLANGE OF RT WING RIB AT WS 171.5, STRINGER 16. AN ANGLE REPAIR WAS FABRICATED AND INSTALLED IAW SRM 51-40-3 AND 51-10-6.SDR CALA9801197Angle · crackedINSPECTION FOUND A CRACK IN AFT END OF LOWER ANGLE AT RT OUTBOARD MID-FLAP INBOARD END RIB. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS FABRICATED AND INTALLED IAW SRM 51-40-2.SDR CALA9801196Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 360, RBL 48. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-1 AND 53-10-5.SDR CALA9801195Bracket · crackedINSPECTION FOUND A .75 INCH CRACK IN NR 5 LEADING EDGE FLAP INBOARD MOUNT BRACKET. THE BRACKET WAS REMOVED AND A NEW BRACKET WAS FABRICATED AND INSTALLED IAW SRM 51-30-2, 51-40-3, AND 51-10-2.SDR CALA9801194Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 380, RBL 18. THE CORRODED AREA WAS CUT OUT IAW SRM 53-10-8. A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8, 51-10-2, AND 51-40-4.SDR CALA9801193Skin · tornINSPECTION FOUND A 1 TEAR IN UPPER RUDDER RT SIDE TRAILING EDGE SKIN. THE TORN AREA WAS CUT OUT. A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-40-2.SDR CALA9800830Hyd Line · leakingDURING CLIMB, B-SYSTEM HYDRAULIC QUANTITY WENT TO ZERO. FOUND LEAKING HYDRAULIC LINE. REPLACED LINE.SDR CALA9800254Skin · crackedINSPECTION FOUND A .625 INCH CRACK AND TWO SHEARED FASTENERS IN LEFT WINGTIP LOWER TRAILING EDGE SKIN. THE FASTENERS WERE REMOVED AND THE CRACK WAS STOP DRILLED. A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-40-02.SDR CALA9800253Rib · crackedINSPECTION FOUND A 1.5 CRACK IN WINGTIP MOUNT RIB AT WINGTIP AREA AFT OF NAV STROBE LIGHT. AN ANGLE DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-40-3.SDR CALA9800252Doubler · crackedINSPECTION FOUND A 2 INCH CRACK IN DOUBLER OF RT WINGTIP TRAILING EDGE AT WBL 626. THE WINGTIP WAS REMOVED AND A NEW DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-40-2. THE WINGTIP WAS REINSTALLED IAW SRM 51-30-2 AND MM 33-40-0.SDR CALA9800251Skin · debondedINSPECTION FOUND LT INBOARD FOREFLAP INBOARD TRAILING EDGE SKIN DEBONDED WITH CHAFE MARKS ALONG UPPER SURFACE. THE FOREFLAP WAS REMOVED, REPAIRED AND REPLACED.SDR CALA9800250Skin · crackedINSPECTION FOUND A 1.375 CRACK IN LT WING NR 4 SPOILER AT LOWER SKIN JUST INBOARD OF SECOND FROM INBOARD HINGE. THE NR 4 SPOILER WAS REMOVED AND REPLACED.SDR CALA9800232Casting · crackedINSPECTION FOUND A 1 INCH CRACK IN LT OUTBOARD FOREFLAP OUTBOARD END CASTING LOWER ATTACH LUG. THE LT OUTBOARD FOREFLAP VANE WAS REMOVED AND REPLACED IAW MM 27-50-00.SDR CALA9800231Angle · crackedINSPECTION FOUND A 3 INCH CRACK IN LT WING NR 2 SLAT CHORD ANGLE BELOW WHERE INBOARD STOP PAD MOUNTS. A NEW ANGLE WAS FABRICATED AND INSTALLED IAW SRM 51-10-01.SDR CALA9800230Skin · crackedINSPECTION FOUND SEVERAL .375 INCH CRACKS FROM FASTENER HOLE AT NR 4 SLAT UPPER SKIN WHERE INBOARD HOOK MOUNTS. TWO .375 INCH CRACKS WERE FOUND AT NR 4 SLAT UPPER SKIN WHERE OUTBOARD HOOK MOUNTS. DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 57-50-3.SDR CALA9800229Wire · brokenINSPECTION FOUND THE LEFT AND RIGHT FORWARD OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. MAINTENANCE FOUND A BROKEN WIRE AT CANNON PLUG. THE WIRE WAS REPAIRED AND THE BATTERIES WERE CHARGED.SDR CALA9800228Light · inoperativeINSPECTION FOUND THE RT AFT GALLEY DOOR EMERGENCY EXIT LIGHT TOO DIM. THE LIGHT ASSEMBLY WAS REPLACED IAW MM 33-50-101.SDR CALA9800227Frame · corrodedINSPECTION FOUND C-3 DOOR FRAME CORRODED AT CUTOUT AT FORWARD LOWER END WHERE IT MEETS THRESHOLD AT BS 1090. THE CORRODED AREA WAS CUT OUT. A DOUBLER AND FILLER REPAIR WAS INSTALLED IAW SRM 51-40-3.SDR CALA9800226Rib · crackedINSPECTION FOUND A 2 CRACK IN NR 2 LEADING EDGE SLAT RIB OUTBOARD OF ANTI-ICE DUCT. A REPAIR ANGLE WAS FABRICATED AND INSTALLED IAW SRM 57-50-3.SDR CALA9800222Splice Plate · crackedINSPECTION FOUND A 2 INCH CRACK AT SPLICE PLATE INSIDE LEFT WING UPPER LEADING EDGE ABOVE NR 2 LEADING EDGE FLAP ACTUATOR/ANTI-ICE DUCT AREA, WS 224.5. THE SPLICE PLATE WAS REMOVED AND A STRAP WAS FABRICATED AND INSTALLED IAW SRM 57-50-2 AND 51-30-2.SDR CALA9700043Support · corrodedINSPECTION FOUND FORWARD CARGO BAY FLOOR SUPPORT TRACK CORRODED AT BS 640, STRINGER 28L. A FLOOR SUPPORT TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-10-2, FIGURE 8, SRM 51-10-6, AND 51-30-2.SDR CALA9700042Channel · corrodedINSPECTION FOUND FORWARD CARGO BAY SIDEWALL FLOOR SUPPORT CHANNEL CORRODED AT BS 540, STRINGER 27R. A FLOOR SUPPORT CHANNEL WAS FABRICATED AND INSTALLED IAW SRM 51-30-1 AND 53-10-8.SDR CALA9700041Stringer · corrodedINSPECTION FOUND STRINGER 28L CORRODED AT BS 520. A STRINGER AND SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-3, FIGURE 1.SDR CALA9700044Floor · corrodedINSPECTION FOUND NR 2 GALLEY UPPER COMPARTMENT FLOOR CORRODED. THE CORROSION WAS REMOVED, TWO DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 51-40-2 AND 51-10-1.SDR CALA9601045Pack · smokingWHILE OPERATING RT PACK IN MANUAL WITH MIX VALVE AT HALF POSITION, THE RIGHT PACK TEMP WENT TO 150 DEGREES AND WAS ACCOMPANIED BY CABIN SMOKE DURING DESCENT INTO EWR. THE SMOKE CLEARED WHEN COOLING DOOR WAS OPENED AND MIX VALVE WAS ADJUSTED. THE AIRCRAFT LASDR CAL950029Transmission · inoperativeIAH - FLT 0414 - THE OUTBOARD FLAPS HAD A HISTORY OF NOT EXTENDING BOTH ON THE GROUND AND IN-FLIGHT. MAINTENANCE FOUND EXCESSIVE SHAFT PLAY IN THE NR 8 FLAP TRANSMISSION. THE NR 8 FLAP TRANSMISSION WAS REMOVED AND REPLACED. THE FLAPS WERE OPERATED ELECTRICA
Back to N69735, cancelled Jul 29, 2011