N863GA, cancelled Jun 29, 2024
Service difficulty reports · 97
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 = 'N863GA' AND deregistration_id = 'N863GA-2024-06-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 = 'N863GA' AND deregistration_id = 'N863GA-2024-06-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 WX0A2018022873308Fuel Heater · leakingSTRONG FUEL SMELL THROUGHOUT AIRCRAFT. R&R LEAKING APU FUEL HEATER.SDR WX0A2018022373307Apu · faultySTRONG FUEL SMELL THROUGHOUT ENTIRE PLANE WITH APU AIR ON. R&R APU.SDR JR2R201707080005Skin · crackedL1 DOOR HOLD OPEN HOOK CUP AND SURROUNDING SKIN IS DAMAGED. REPAIRED IAW EA 20-2017-130.SDR JR2R20170416182Doubler · corrodedAFT CARGO PIT INTERNAL DOUBLER FOUND TO BE CORRODED WHILE WORKING DOOR JAMB FITTING STA 1156 TO 1211.SDR JR2R20170416183Beam · corrodedAFT CARGO DOOR BEAM FOUND CORRODED AT STA 1174 TO 1194. REMOVED AND REPLACED AFT CARGO BEAM AT LONG 28R STA 1117 TO STA 1250 IAW SRM 51-30-5.SDR JR2R20170414184Frame · corrodedFUSELAGE FRAME IN MID PIT CORRODED. REPAIRED FRAME IAW EA 20-2017-064.SDR JR2R20170413073Fitting · corrodedAFT CARGO DOOR FWD LOWER CORNER DOOR JAMB FITTING CORRODED. REMOVED AND REPLACED AFT CARGO GOORFWD LOWERCORNER JAMB FITTING IAW SRM 51-30-5.SDR JR2R20170413268Support Angle · crackedLEFT OTBD FLAP CENTER HINGE FAIRING SUPPORT ANG;E ON FUEL PANEL CRACKED. REMOVED AND REPLACED THE SUPPORT ANGLE IAW SRM 51-30-5.SDR JR2R20170413345Stiffener · crackedNR 1 ENGINE NOSE COWL STIFFENER CRACKED. REMOVED AND REPLACED THE STIFFENER IAW SRM 51-30-2.SDR JR2R20170413341Rib · crackedRIGHT WING LE RIB CRACKED. REMOVED AND REPLACED THE RIB IAW SRM 51-30-2.SDR JR2R20170413246Window Frame · crackedPASSENGER CABIN LEFT BS 965 UPPER FWD CORNER OF WINDOW FRAME WEB CRACKED. REMOVED DAMAGE AND INSTALLED A REPAIR ANGLE AND SHIM IAW SRM 53-05.SDR JR2R20170412169Fitting · crackedRT WING LE CLIP CRACKED. REMOVED AND REPLACED CLIP IAW SRM 51-30-2.SDR JR2R20170412348Support · corrodedAFT CARGO FRAME TO BEAM SUPPORT CORRODED. REMOVED AND REPLACED SUPPORT IAW SRM 51-10-4.SDR JR2R20170411279Support · crackedVERTICAL FLOORBEAM SUPPORT CRACKED. REMOVED AND REPLACED FLOORBEAM SUPPORT IAW DRAWING 9936637 AND SRM 51-30-3.SDR JR2R20170411269Support · crackedFWD CARGO LOWER BULKHEAD SUPPORT CRACKED. REMOVED AND REPLACED FWD LOWER BULDHEAD SUPPORT IAW SRM 51-10-4 FIG 3.SDR JR2R10170411349Fitting · corrodedCLIP IS CORRODED. REMOVED AND REPLACED CLIP IAW SRM 51-10-4.SDR WX0A201610043189Fmc · failedAFTER TAKE OFF, HAD A COMPLETE NAVIGATION FAILURE, BOTH FMC, BOTH NAV DISPLAYS. PREFORMED FLIGHT FAULT REVIEW. , REMOVED AND REPLACED FMC IAW AMM 34-63-03, DFGC RTS 1 & 2 IAW AMM 22-01-05. AIRCRAFT RETURNED TO SERVICE"SDR WX0A20160802176Computer · failedSLAT FLAP DISAG LIGHT ILLUMINATED DURING FLIGHT WITH CLEAN WINGS WITH EQRH PAGE 27.8 DISAGREE LIGHT EXTINGUSHED WHEN FLAPS 11 AT 10,000' RETRACTED SLATS RAN CHECK LIST. INDICATIONS NORMAL PASSING 15,000', SLAT CAWS WARNING SOUNDED. WITH DISAGREE LIGHT ILLUMISDR WX0A201607153176Warning Message · illuminatedSLAT FLAP DISAGREE LIGHT ILLUMINATED DURING FLIGHT WITH CLEAN WINGS WITH EQRH PAGE 27.8 DISAGREE LIGHT EXTINGUSHED WHEN FLAPS 11 AT 10,000' RETRACTED SLATS RAN CHECK LIST (CLIMB) INDICATIONS NORMAL PASSING 15,000'. SLAT CAWS WARN SOUNDED. WITH DISAGREE LIGHTSDR WX0A2016040173124Unknown · not reportedON CLIMB OUT, PLATFORM 1 DATA FAIL, FIRST OFFICERS ATTITUDE INDICATOR WAS NOT STABLE & WAS ERRATIC. AUTOPILOT & AUTO THROTTLE DISENGAGED, THEN RE-ENGAGED. PROBLEM REPEATED, SWITCHED AUTOPILOT TO NR 1. FIRST OFFICERS ATTITUDE INDICATOR STILL INTERMITTENTLY ESDR WX0A2016040173117Computer · malfunctionedON CLIMB OUT, DUAL PLATFORM FAIL WAS INDICATED AFTER LOSING FLIGHT DIRECTOR, AUTO THROTTLE & AUTO PILOT. SYS CAME BACK AFTER 25 MIN RETURN TO FIELD. BOTH 1 & 2 VG'S, NR 1 DFGC R & R & WIRING CHECKS OF VGS SEE LOG PAGE 677417 & WO 293781, 293769, 293770 & 29SDR WX0A2015122873053Pseu · faultyLEFT MAIN GEAR UNSAFE ILLUMINATED. PERFORMED BITE OF PSEU. FOUND FAULT CODES 380, 580, 810, & 840. REPLACED PSEU & OPERATIONS CHECKED GOOD IAW AMM 32-60-04.SDR WX0A2015110272975Light · inoperativeBOTH LT & RT AFT OVERWING EMER EXIT SIGNS INOPERATIVE. RE-LAMPED BOTH AFT OVERWING EMER EXIT SIGNS. OPERATIONS CHECKED GOOD IAW AMM 33-53-00.SDR WX0A2015102872965Door Frame · corrodedAFT CARGO DOOR CUT OUT, AFT FRAME CORRODED STATION 1212, BETWEEN LONGERON 24L & 25L. REMOVED DAMAGED AREA, ACCOMPLISHED HFEC OF CUT EDGES, NO CRACKS NOTED. FABRICATED REPAIR ANGLES, FILLER, LOCATED, DRILLED & INSTALLED REPAIR PARTS IAW EA 15-2015-076.SDR WX0A2015101272941Pan · crackedAFT CARGO BAY INNER EDGE, SKIN IS CRACKED AT AFT DOOR CATCH ANGLE BRACKET. REPAIRED AFT CARGO DOOR INNER SKIN AT AFT DOOR CATCH ANGLE IAW EA 32-2015-375. WORK ACCOMPLISHED ON WO 00266525 M301 ITEM 65.SDR WX0A2015101272940Skin · corrodedFORWARD LOWER CORNER OF AFT LAVATORY SERVICE DOOR, CUT OUT HAS CORROSION. REPAIRED FUSELAGE SKIN AT AFT SERVICE DOOR CUT OUT, FWD CORNER IAW EA 30-2015-435. WORK ACCOMPLISHED ON WO 00266525 M301 ITEM 45.SDR WX0A2015041372526Actuator · malfunctionedON TAKEOFF, AFTER LANDING GEAR HANDLE BEING MOVED TO UP POSITION GEAR FAILED TO RETRACT. 3 RED GEAR UNSAFE LIGHTS WERE ILLUMINATED & GEAR REMAINED PARTIALLY RETRACTED AS EVIDENCE BY INCREASED DRAG & WIND NOISE. QRH 32.9 EXTENDED & RETRACTED GEAR, GEAR UNSAFESDR WX0A072525Warning System · false activationLEFT GEAR UNSAFE LIGHT REMAINED ILLUMINATED AFTER GEAR RETRACTION AFTER TAKEOFF. RUN QRH 32.9, LIGHT EXTINGUISHED AFTER CYCLING LANDING GEAR. PERFORMED VISUAL INSPECTION OF MLG'S & DOOR AREA. RUN A PROXIMITY BOX TEST & NO DEFECTS NOTED AT THIS TIME REF AMMSDR WX0A2015031672467Ballast · defectiveJUST AFTER BOTH ENGS WERE STARTED FLIGHT ATTENDANTS & PAX'S COMPLAINED OF SMOKE SMELL FROM ROW 15 ALL THE WAY TO AFT OF THE AIRPLANE. ONE PAX SAID THEY SAW SMOKE AT 16AC. APU WAS STILL RUNNING. NO SMOKE WARNINGS IN COCKPIT OR CABIN. FOUND BALLAST AT 16AC HASDR WX0A2015021672420Power Supply · inoperativeBOTH L1 & R1 EMER EXIT SIGNS INOPERATIVE. REPLACED POWER SUPPLY & OPERATIONS CHECKED OK IAW AMM 33-53-00.SDR WX0A2014122272312Flashlight · inoperativeTOP EMER FLASHLIGHT AT FWD FLIGHT ATTENDANT STATION INOPERATIVE. R & R TOP EMER FLASHLIGHT AT FWD FLIGHT ATTENDANT STATION IAW AMM 25-60-00. OPERATIONS CHECKED GOOD.SDR WX0A2014100772191Oxygen Mask · inoperativeCAPTAIN O2 MASK WILL NOT INFLATE TO DON. REPLACED MASK, OPERATIONS CHECKED GOOD IAW MM 35-10-03.SDR WX0A072025Life Vest · missingONE CREW LIFE VEST MISSING. INSTALLED CREW LIFE VEST IAW AMM 25-60-00.SDR WX0A071922Battery · dischargedFLIGHT ATTENDANT`S REPORTED AFTER DEPLANING PAX THAT THE FWD MEGA PHONE TESTED DURING PREFLIGHT. BUT DURING PAX DEPLANING FOR APU SMOKE, AFT FLIGHT ATTENDANT`S SAID THEY COULD NOT HEAR THE MEGA PHONE. R & R MEGA PHONE BATTERIES IAW AMM 23-30-01, OPERATIONS CSDR WX0A071903Skin · gougedLEFT OTBD FLAP OTBD FIXED VLV GAP GOUGED. REMOVED DAMAGED SKIN, FABRICATED REPAIR DOUBLER & FILLER & INSTALLED REPAIR PARTS IAW SRM 57-03.SDR WX0A071894Skin · corrodedEXTERIOR FUSELAGE SKIN CORRODED AT STATION 826 LONGERON 29R. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-04 FIG 57.SDR WX0A071893Door Frame · crackedFORWARD ACCESSORY COMPARTMENT DOOR PAN CRACKED AT 7 O' CLOCK POSITION. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-01 FOG 2 SHEET 4.SDR WX0A071888Cargo Track · corrodedTIE DOWN RAIL ON THE LT SIDE IS CORRODED FROM FS 1200 TO FS 1322. R & R AFT CARGO BAY TIE DOWN RAIL FROM FS 1200 TO FS 1322 IAW SRM 51-30-1 & SRM 51-30-5.SDR WX0A071892Cusp Web · corrodedRT CUSP WE CORRODED ON LOWER SURFACE JUST AFT OF STATION 598. REMOVED DAMAGE, FABRICATED DOUBLER, FILLER, RING DOUBLER & INSTALLED REPAIR IAW SRM 53-05 FIG 131A-4.SDR WX0A071885Cusp Web · corrodedRIGHT CUSP WEB CORRODED ON LOWER SURFACE AFT OF FS 598. REMOVED DAMAGE, FABRICATED DOUBLER, FILLER & RING DOUBLER & INSTALLED REPAIR IAW SRM 53-05 FS 131 A-4.SDR WX0A071886Cusp Web · corrodedPASSENGER CABIN LT CUSP WEB STATION 446 TO 465 IS CORRODED. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-05 FIG 131A-6.SDR WX0A071887Tab · dentedLEFT ANTI-FLOAT TAB DENTED OUT OF LIMITS ON UPPER SURFACE 5 INCHES INBD OF INBD HINGE. REMOVED DAMAGE, FABRICATED FILLER, DOUBLER & HOT BONDED IAW SRM 51-70-2 PARA 13 PAGE 64. BOND TESTED GOOD IAW NDTSPM 05-10-002.001. WEIGHT & BALANCED 12.175 LBS MOMENT -4SDR WX0A071883Web · corrodedAFT PIT CARGO DOOR CUTOUT FWD WEB CORRODED STATION 1150 BETWEEN LONGERONS 23R & 25R. CUTOUT DAMAGED AREA, FABRICATED, LOCATED, DRILLED & INSTALLED WEB SECTION IAW SRM 53-01 FIGURE 4 SHEET 4.SDR WX0A071884Membrane · crackedCABIN CUSB WEB MEMBRANE DENTED & CRACKED STATION 165 JUST INBD OF L1 DOOR THRESHOLD. CUTOUT DAMAGED AREA, HFEC INSPECTED NO CRACKS NOTED IAW NTSPM PROCEDURE 1 06-10-01.001. FABRICATED REPAIR DOUBLER & INSTALLED IAW SRM 53-01 PAGE 25 FIGURE 4 SHEET 4 NOTE 5.SDR WX0A071880Membrane · crackedCABIN CUSB WEB MEMBRANE DENTED & CRACKED STATION 165 JUST INBD OF L1 DOOR THRESHOLD. CUTOUT DAMAGED AREA, HFEC INSPECTED NO CRACKS NOTED IAW NTSPM PROCEDURE 1 06-10-01.001. FABRICATED REPAIR DOUBLER & INSTALLED IAW SRM 53-01 PAGE 25 FIGURE 4 SHEET 4 NOTE 5.SDR WX0A2013111800754Unknown · smokeELECTRICAL ODOR AND LIGHT BLUE/GREY HAZE WAS DETECTED DURING THE BOARDING PROCCESS. IT APPEARS TO BE COMING FROM ROW 20 TO 11 FROM THE EMERGENCY EXIT ROW, FORWARD ON THE ACFT RT SIDE. INSPECTED ACFT FOR DISCREPANT ODOR C/W ODOR/SMOKE TASK CARD NO DEFECTS NOTSDR WX0A201308130056Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE. MX R & R POWER SUPPLY BATTERY PACK. OPS CHECKED IAW AMM 33-50-00, SYS OPS CHECKED NORMAL. ACFT RETURNED TO SERVICE.SDR WX0A201308010045Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION, MX REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYS WOULD NOT TEST. MX R & R BATTERY PACK AND OPS CHECK ACCOMPLISHED IAW AMM 33-50-00, SYSTEM OPS CHECKED NORMAL. ACFT RETURNED TO SERVICE.SDR WX0A201308010044Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION, MX REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYS WOULD NOT TEST. MX R & R BATTERY PACK AND OPS CHECK ACCOMPLISHED IAW AMM 33-50-00, SYS OPS CHECKED NORMAL. ACFT RETURNED TO SERVICE.SDR WX0A201308050052Metering Valve · damagedCARGO MID LOOP B LIGHT ILLUMINATED ALONG WITH "SMK DET LOOP" AND MASTER CAUTION. DETERMINED LIGHT WAS FAULTY AND TO CONTINUE TO DESTINATION. WITHIN A FEW MINUTES "MASTER WARNING" "CARGO FIRE" AND CDSP "FIRE" LIGHTS ILLUMINATED ALONG WITH AURAL WARNING. PER
Back to N863GA, cancelled Jun 29, 2024