N807AL, cancelled Jul 30, 2008
Service difficulty reports · 104
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 = 'N807AL' AND deregistration_id = 'N807AL-2008-07-30' 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 = 'N807AL' AND deregistration_id = 'N807AL-2008-07-30' 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 TSAA9933403Battery Pack · dischargedREPLACED NR 1 FLOOR LIGHT EMERGENCY BATTERY PACK DUE TO INOPERATIVE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9933402Light · inoperativeREPLACED FORWARD SERVICE EMERGENCY IDENTIFIER LIGHT ASSY DUE TO INOPERATIVE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9933357Battery Pack · dischargedREPLACED NR 3 PROXIMITY LIGHT BATTERY PACK DUE TO INOPERATIVE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9933250Light · inoperativeREPLACED NR 6 POSITION FLOOR EMERGENCY LIGHT ASSEMBLY DUE TO INOPERATIVE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9957242Flap · crackedLEFT OUTBOARD MID FLAP CRACKED AT AFT FLAP INBOARD TRACK ATTACH POSITION. CRACKED AT BOTH INBOARD AND OUTBOARD TRACK ARM POSITION. REMOVED AND REPLACED MID FLAP IAW 27-51-72, OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9957271Panel · corrodedRIGHT WING LOWER ACCESS PANEL CUT-OUT AT PANEL NR 7406 CORRODED. BLENDED OUT CORROSION PER SRM 57-30-3, AND AREA RE-ASSESSED BEYOND LIMITS PER SRM 57-30-3. FILLER FABRICATED IAW ECO 2869 PT1. AREAS REFINISHED WITH BMS 10-20 TYPE II PER MM 53-42-11. (X)SDR TSAA9953277Washer · defectiveHORIZONTAL STABILIZER AFT ATTACH FITTINGS UPPER AND LOWER BOLTS HAVE MIGRATING WASHERS UNDER THE NUTS. REPAIR IAW ECO 2975. AIRCRAFT RETURNED TO SERVICE. TAT: 30,874.2 HOURS. TAC: 38,783. (X)SDR TSAA9953268Bushing · corrodedVERTICAL FIN AFT SIDE OF RIGHT OUTBOARD AFT SPAR ATTACH FITTING CORRODED UNDER BUSHING FLANGE. REPAIR IAW ECO 2973. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9953267Bushings · corrodedFUSELAGE LUGS FOR VERTICAL FIN AFT SPAR ATTACH HAVE HEAVY FRETTING ON FACES ON BUSHINGS. REPAIRED PER ECO 2978. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9952275Frame · crackedAFT CARGO DOOR FORWARD FRAME SUSPECT 3 CRACKS RADIATING FROM BOLT HOLE IN CENTER OF FORWARD FRAME. REPAIRED IAW ECO 2971. AIRCRAFT RETURNED TO SERVICE. TAT: 30,874.2 HOURS. TAC: 38,783. (X)SDR TSAA9952273Frame · crackedFORWARD CARGO PIT DOOR LOWER AFT CORNER FRAME CRACKED. REPAIRED IAW ECO 1988R1. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9933019Battery Pack · dischargedREPLACED FORWARD SLIDE LIGHT BATTERY PACK DUE TO INOP. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9933004Light · inoperativeREPLACED FORWARD SERVICE DOOR EMERGENCY EXIT IDENTIFIER LIGHT ASSY DUE TO INOP. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833662Light · inoperativeREPLACED EXIT IDENTIFIER LIGHT ASSY FOR FORWARD ENTRY DOOR DUE TO INOPERATIVE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833629Battery Pack · dischargedREPLACED NR 5 EMERGENCY BATTERY PACK DUE TO LOW VOLTAGE. OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833604Battery Pack · dischargedREPLACED NR 5 FLOOR LIGHT BATTERY PACK FOR RETIREMENT. REPLACED BATTERY, OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9879582Switch · malfunctionedFLT 297 - OGG-HNL - ON CLIMB-OUT, NR 1 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED IN FLIGHT. REDUCED NR 1 ENGINE THROTTLE TO IDLE AND LIGHT STAYED ON. NR 1 ENGINE WAS SHUT DOWN IAW THE QRH. EMERGENCY DECLARED AND UNEVENTFUL LANDING MADE AT HNL. INSPECTED OSDR TSAA9833513Battery Pack · dischargedREPLACED NR 2 POSITION EMERGENCY FLOOR PROXIMITY LIGHT BATTERY PACK DUE TO LOW VOLTAGE. OPS CHECKED OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833509Light · inoperativeREPLACED EMERGENCY EXIT LIGHT AT FORWARD ENTRY DOOR DUE TO BEING INOP. OPS CHECKED OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833359Battery Pack · dischargedREPLACED NR 4 EMERGENCY FLOOR LIGHT BATTERY PACK DUE TO BEING INOP. OPS CHECKED OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9853318Skin · crackedFUSELAGE SKIN CRACK APPROXIMATELY 2.5 INCHES LONG AT BS 787 AND STR 18L. VERIFIED CRACK USING HIGH FREQUENCY EDDY CURRENT. REPAIRED PER SRM 53-30-3 FIG 1. AIRCRAFT RETURNED TO SERIVCE. TAT: 29,087.1 HRS. TAC: 34,722. (X)SDR TSAA9833250Battery Pack · dischargedREPLACED NR 1 POSITION EMERGENCY FLOOR LIGHT ASSY, INOPERABLE. REPLACED BATTERY PACK. OPS CHECKED OK. AIRCRAFT RETURNED TO SERVICE. (X)SDR TSAA9833245Battery Pack · dischargedREPLACED NR 6 POSITION EMERGENCY FLOOR LIGHT ASSY, INOPERABLE. REPLACED BATTERY PACK. OPS CHECKED OK. AIRCRAFT RETURNED TO SERVICE. (X)SDR TSAA9833215Battery Pack · dischargedOUTSIDE LEFT SIDE OVERWING EMERGENCY LIGHTS INOP. REPLACED BATTERY POWER SUPPLY. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833220Light · inoperativeREPLACED NR 5 POSITION EMERGENCY FLOOR LIGHT ASSY DUE TO YELLOW LED STAYING ON ALL THE TIME IN POSITION. OPS CHECKED OK AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9855214Bushing · corrodedHORIZONTAL STABILIZER RT SIDE UPPER AFT BUSHING CORRODED. REPAIRED BUSHING PER ECO 2895. BLEND OUT DIMENSION 1.2560 INCH BY 1.2640 INCH. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9853216Frame · corrodedAPPLIED PREVENTATIVE MODIFICATION TO AFT LOWER CARGO DOORWAY FORWARD AND AFT BODY FRAMES PER ECO 1474R9. DEVIATION 'F' APPLIED TO ECO 1474R9 INSTRUCTIONS DUE TO CORROSION ON FORWARD FRAME WEB. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9853212Fitting · corrodedFOUND CORRODED END FITTING AT BS 1016 AFT PRESSURE BULKHEAD AND STRINGER 20L. REPLACED FITTING PER ECO 2894. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9857213Skin · corrosionCORROSION FOUND ON LEFT SIDE OUTBOARD WING LOWER SKIN AT WING STATION 495. REWORKED AREA PER ECO 1684R8 AND DEVIATION 'F' FOR ECO 1684R8. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9853160Skin · crackedON SERVICE CHECK, FUOND A FUSELAGE SKIN CRACK AT BS 850 STRINGER 21R. REPAIRED PER SRM 53-30-3 FIG 6. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9833020Battery Pack · dischargedON SERVICE CHECK, FOUND LT OVERWING EMERGENCY LIGHT INOPERABLE. REPLACED BATTERY PACK. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. TAT: 28,188:25 HOURS. TAC: 32,705. (X)SDR TSAA9733384Bulb · failedON SERVICE CHECK, FOUND LEFT WING EMERGENCY SLIDE LIGHT INOP. REPLACED BULB. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9733361Sign · brokenON SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY LIGHT BROKEN. REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD. AIRCRAFT REUTRNED TO SERVICE. TAT: 28,070:37 HOURS. TAC: 32,446. (X)SDR TSAA9733355Battery Pack · dischargedON SERVICE CHECK, FOUND FORWARD SLIDE LIGHT INOPERABLE, REPLACED BATTERY PACK. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. TAT: 28,063:56 HOURS. TAC: 32,432. (X)SDR TSAA9733349Floor Beam · corrodedUPON INSPECTION OF ECO 2317 BS 294.5 FLOOR BEAM FOR CRACKS, CORROSION WAS FOUND AT BS 294.5 STR 17R. REPAIRED PER ECO 2867. AIRCRAFT RETURNED TO SERVICE. TAT: 28,046:22 HOURS. TAC: 32,394. (X)SDR TSAA9733347Battery Pack · dischargedON SERVICE CHECK, FOUND THE NR 6 POSITION EMERGENCY FLOOR LIGHTING INOPERABLE. REPLACED BATTERY PACK, OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. TAT: 28,046:22 HOURS. TAC: 32,394. (X)SDR TSAA9733346Battery Pack · dischargedON SERVICE CHECK, FOUND THE NR 5 POSITION EMERGENCY FLOOR LIGHTING INOPERABLE. REPLACED BATTERY PACK, OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. TAT: 28,046:22 HOURS. TAC: 32,394. (X)SDR TSAA9733345Battery Pack · dischargedON SERVICE CHECK, FOUND THE NR 1 POSITION EMERGENCY FLOOR LIGHTING INOPERABLE. REPLACED BATTERY PACK. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. TAT: 28,046:22 HOURS. TAC: 32,394. (X)SDR TSAA9733329Power Supply · inoperativeON SERVICE CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INTERMITTENT. REPLACED POWER SUPPLY. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (X)SDR TSAA9733326Solenoid · malfunctionedFLT 201 - HNL-LIH - LANDING GEAR LEVER WOULD NOT MOVE TO THE UP POSITION AFTER TAKEOFF. COMPLIED WITH QRH, NO HORN AFTER FLAPS RETRACTED PROBLEM WITH LEVER LACKING SOLENOID. JACKED AIRCRAFT, NOTED SAFETY SOLENOID ENGAGED ON LANDING LEVER. PERFORMED AIR SAFESDR TSAA9733309Power Supply · inoperativeON SERVICE CHECK, FOUND LEFT OVERWING EMERGENCY LIGHT INOP. REPLACED BATTERY POWER SUPPLY. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9733308Power Supply · inoperativeON SERVICE CHECK, FOUND FORWARD EMERGENCY SLIDE LIGHT INOP. REPLACED BATTERY POWER SUPPLY. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9733263Power Supply · inoperativeDURING OVERNIGHT CHECK, REPLACED BATTERY POWER SUPPLY FOR LT EXTERIOR OVERWING EMERGENCY LIGHT DUE TO LIGHT REMAINS ON. OPERATIONAL CHECK OK. AIRCRAFT RETURNED TO SERVICE. TAT: 27,780:23 HOURS. TAC: 31,804. (X)SDR TSAA9733256Light · inoperativeDURING OVERNIGHT CHECK, REPLACED RT OVERWING EXIT IDENT LIGHT ASSY DUE TO INOPERABLE. OPERATIONAL CHECK OK. AIRCRAFT RETURNED TO SERVICE. TAT: 27,690:21 HOURS. TAC: 31,613. (X)SDR TSAA9733220Battery · dischargedDURING OVERNIGHT CHECK, REPLACED BATTERY FOR ROW 8 EMERGENCY FLOOR PROX LIGHT ASSY DUE TO INOP. OPERATIONAL CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA9753170Frame · crackedDURING SCHEDULED INSPECTION OF AFT LOWER CARGO DOORWAY, FORWARD AND AFT BODY FRAME (FAA AD 93-14-10 AMDT 39-8-8634), FOUND CRACK PROPAGATING FROM UNDER NR 5 STOP ON AFT BODY FRAME. JFEC CONFIRMED. REPLACED AFT BODY FRAME PER ECO 1474R7. AIRCRAFT RETURNED TO SDR TSAA9733177Battery · dischargedDURING OVERNIGHT CHECK, REPLACED ROW 22 EMERGENCY FLOOR LIGHT BATTERY DUE TO INOPERABLE. OPERATIONAL CHECK OK. AIRCRAFT RETURNED TO SERVICE. TAT: 27,199:07 HOURS. TAC: 30,493. (X)SDR TSAA9733176Light · inoperativeDURING OVERNIGHT CHECK, ADJUSTED FORWARD ENTRY DOOR EMERGENCY EXIT IDENTIFIER DUE TO INOPERABLE. OPERATIONAL CHECK OK. AIRCRAFT RETURNED TO SERVICE. TAT: 27,199:07 HOURS. TAC: 30,493. (X)SDR TSAA9753156Compressor · stalledHNL/KOA - FLT 86 - PILOT REPORT, LOUD BANG AND YAW PASSING 9,000 FEET AFTER TAKEOFF. ENGINE INSTRUMENTS LOOK NORMAL. RETURNED TO HNL. VISUALLY INSPECTED BOTH ENGINES, FUSELAGE, AND CONTROL SURFACES. NO VISUAL DEFECTS NOTED. EXERCISED FLIGHT CONTROLS AND VSDR TSAA9753154Skin · crackedDURING OVERNIGHT CHECK, FOUND FUSELAGE SKIN CRACK .50 INCH LONG AT BS 787 + 3 INCHES APPROXIMATELY 1 INCH BELOW S17L. CONFIRMED BY HFEC. REPAIRED PER SRM 53-30-3. AIRCRAFT RETURNED TO SERVICE. TAT: 27,160:45 HOURS. TAC: 30,404. (X)
Back to N807AL, cancelled Jul 30, 2008