N642GT
Service difficulty reports · 622
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 = 'N642GT' AND registry_match = 'registration' 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 = 'N642GT' AND registry_match = 'registration' 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 UIEA2014051700198Connector · dirtySTATUS MSG APU LP 1 DISPLAYS INTERMITTENTLY. PERFORMED TROUBLESHOOTING. CLEANED & INSPECTED CONNECTORS, RECONNECTED IAW AMM 26-15-02, FIM 26-15-00, FAULT TREE 803 & SWPM 20-60-01. NO FAULTS PRESENT AT THIS TIME.SDR UIEA2014051700197Relay · defectiveAPU BLEED INOPERATIVE. TRANSFERRED TO MDDR 48227, DEFERRED IAW DDPG 49-11-01-01 CAT C PLACARD. R & R RELAY K23 AT PANEL P49 IAW SWPM 20-81-22. OPERATIONS CHECKED OF APU SOV GOOD IAW AMM 36-11-10. THIS CLEARS MDDR 48227, MCC NOTIFIED & PLACARD REMOVED.SDR UIEA2014051200176Bleed Air Sys · inoperativeAPU BLEED INOPERATIVE.SDR UIEA2014051200173Unknown · malfunctionedTERR MODE NOT DISPLAY CORRECT INFORMATION IN FLT. ACCOMPLISHED WEATHER RADAR OPERATIONS CHECK IAW AMM 34-43-00-215-026-002 & OPERATIONS CHECK OF EGPWS IAW AMM 34-46-00, ALL INDICATION NORMAL.SDR UIEA2014042800158Valve · malfunctionedAPU AIR INOPERATIVE. R & R APU SHUTOFF VLV IAW AMM 36-11-10, VLV CHECKED GOOD. FOUND LEAKING AIR DUCT IAW AMM 36-11-02. APU DUCT OPERATIONS CHECKED GOOD.SDR UIEA2014042600157Status Message · intermittentINTERMITTENT STATUS MSG, APU FIRE LOOP 1, IN FLIGHT. OPERATIONS CHECKED IAW MM 26-15-00, NO DEFECTS NOTED AT THIS TIME.SDR UIEA2014042200156Switch · faultyLEFT AFT FUEL PUMP WON’T TURN OFF. REPLACED BOOST PUMP LT AFT SWITCH, IAW SWPM 20-84-14. OPERATIONS CHECKED IAW AMM 28-22-03, MDDR CLEARED.SDR UIEA2014041600149Battery · faultySTATUS MSG APU BATTERY CHARGER. PERFORMED TROUBLESHOOTING IAW FIM 24-31-805. FOUND APU BATTERY FAULTY, REPLACED IAW AMM 24-31-04. SYS OPERATIONS & GND CHECKED GOOD.SDR UIEA2014040700139Fire Loop · false activationAPU FIRE LOOP ONE STATUS MSG. PERFORMED FIM PROCEDURE 26-15-FAULT TREE 804 & ALL INDICATIONS NORMAL.SDR UIEA2014033100134Fire Warning · false activationSTATUS MESSAGE, APU FIRE LP 1. PERFORM FIM PROCEDURE 26-15 FAULT TREE 804, ALL INDICATIONS NORMAL.SDR UIEA2014032100124Warning System · false activationRUDDER RATIO EICAS MSG, RUDDER RATIO LIGHT ON TAXI OUT. RE RACKED LT & RT RUDDER RATIO BOX, CHECKED TEST SWITCH POSITION, SYS OPERATIONS CHECKED NORMAL IAW FIM 27-21, FAULT TREE 804 & 27-09-00 101, CAT II/III.SDR UIEA2014031400104Unknown · malfunctionedNON-COMMANDED AILERON INPUT, NON-COMMANDED RT AUTOPILOT ENGAGEMENT, NON-COMMANDED VS ENGAGEMENT, NON-COMMANDED HEADING HOLD & NON-COMMANDED STAB TRIM RUNAWAY FULL NOSE UP. FOUND FAULT INDICATION ON RT AILERON STAB TRIM MOSUDE, RESET & ALL INDICATIONS RETURNEDSDR UIEA2014031400105Fire Loop · faultyRT ENG FIRE LOOP 1 DISPLAYED ON STATUS PAGE. R & R LOOP 1 DETECTOR ELEMENT, OPERATIONS CHECKED OK.SDR UIEA2014031200103Acm · seizedLEFT PACK AUTO MODE INOPERATIVE. TROUBLE SHOT IAW FIM, FOUND ACM TURBINE SHAFT SEIZED. REPLACED ACM WITH REPAIRED UNIT IAW AMM 21-51-03. LEAK & GND OPERATIONS CHECKED GOOD, PLACARD REMOVED.SDR UIEA2014031000098Controller · failedRIGHT SIDE WINDOW EICAS MESSAGE. PERFORMED FIM 30-41-801803 WINDOW RESISTANCE 10.3 OHMS, WITHIN LIMITS. REPLACED CONTROLLER IAW AMM 30-41-01, BITE CHECKED GOOD, PLACARD REMOVED.SDR UIEA2014031000100Clamp · unsecureLEFT PACK OVERTEMP DURING GND OPERATION IN AUTO & STANDBY. ACCOMPLISHED FIM PROCEDURE 21 - 51 FAUL TREE 804, FOUND LOW LIMIT CONTROL VLV LEAKING, SECURED CLAMPS, MDDR 46801CLOSED.SDR UIEA2014031000099Pressure Switch · malfunctionedCENTER LT OVRD PUMP PRESS LIGHT ILLUMINATED. TABLE STYLE WIDTH 113PT, BORDER COLLAPSE, COLLAPSE ID 92A3531D-4E0B-4D55-B76A-01D9F2525878. BORDER "0" CELLS PACING "0" CELL PADDING "0" WIDTH "150" "WIDTH, 13PT, WIDTH SOURCE USER SET, WIDTH-ALT 5485, WIDTH "150"SDR UIEA2014030900095Warning System · false activationEICAS MESSAGE, RT SIDE WINDOW, ILLUMINATED IN FLIGHT. PERFORMED OPERATIONAL TEST IAW AMM TASK 30-41-00-715-001, ALL INDICATIONS NORMAL.SDR UIEA2014021900076Switch · inoperativeFORWARD CARGO COMPARTMENT FIRE, ARMED SWITCH, LIGHT INOPERATIVE. R & R FWD CARGO COMPARTMENT FIRE ARMING SWITCH IAW AMM 26-23-01, OPERATIONS CHECKED AMM 26-23-00.SDR UIEA2014021700069Light · inoperativeFORWARD CARGO COMPARTMENT FIRE DETECTIVE SYS WARNING LIGHT INOPERATIVE. RE-LAMPED FWD CARGO LIGHT CAPSULE & OPERATIONS CHECKED OKAY IAW AMM 26-20-08.SDR UIEA2014021300061Igniter · erodedAPU IGNITER PLUG ERODED BEYOND LIMITS. R & R APU IGNITER PLUG IAW AMM 49-41-02. OPERATIONS CHECKED NORMAL.SDR UIEA2014021300058Light · inoperativeL1 MAIN ENTRY DOOR EMERGENCY DOORWAY LIGHT INOPERATIVE WHEN TESTED. REPLACED L1 MAIN ENTRY DOOR EMERGENCY DOORWAY LIGHT BULB IAW AMM 33-51-03, OPERATIONS CHECKED GOOD.SDR UIEA2014021300059Slide · unserviceableL4 DOOR SLIDE LANYARD HAS COME LOOSE FROM THE FIRING MECHANISM AT THE CORNER OF THE DOOR. R & R L4 DOOR ESCAPE SLIDE & RAFT ASSEMBLY IAW AMM 25-66-01.SDR UIEA2014021300062Relay · failedAPU HEALTH CHECK FAILS STEP 5 D OF EO 6749A003, NO 28V DC AT TERMINAL X1. R & R APU START RELAY K197 IAW EO 6749A003 & AMM 49-41-11.SDR UIEA2014013000042Switch · defectiveRIGHT GENERATOR SWITCH COVER WILL NOT STAY LATCHED. REPLACED GEN CONTL SWITCH LIGHT ASSEMBLY.SDR UIEA2014012300027Apu · shutdownPRIOR TO DEPARTURE, APU AUTO SHUTDOWN, APU MDDR 45788. R & R APU IAW AMM 49-11-01, WORK ORDER 6972 TASK CARD T1071.SDR UIEA2014012200023Gauge · faultyFUEL QTY CBE4 ON P6 1 PANEL TRIPPED. TROUBLESHOT IAW FIM 28-41. REPLACED LT TANK QTY LOAD SELECTOR GAUGE IAW AMM 28-41-16, ALL CHECKED GOOD.SDR UIEA2014011600013Isolation Valve · faultyLEFT BLEED ISOL VLV EICAS INTERMITTENT ON LANDING. REPLACED LT BLEED ISOL VLV WITH REPAIRED UNIT IAW AMM 36-11-04. LEAK & OPERATIONS CHECKED GOOD & NBSP.SDR UIEA2014011100008Cooling Fan · inoperativeAFT EQUIP COOLING FAN INOPERATIVE. R & R EQUIP FAN IAW AMM 21- 26-01, OPERATIONS SATISFACTORY.SDR UIEA2013122100611Controller · faultyAFTER SHUT DOWN NR 2 CABIN CONTROLLER STATUS MESSAGE. R & R NR 2 CABIN PRESS CONTROLLER IAW MM 21-31-02 401, OPERATIONS CHECKED OK.SDR UIEA2013121600606Apu · shutdownAPU AUTO SHUTDOWN ON THE GROUND. R & R APU. APU OPERATIONS & LEAK CHECKED GOOD.SDR UIEA2013110600553Ground Wire · failedCARGO FIRE EXT FWD BOTTLE ARM SWITCH "ARM" LIGHT WILL NOT ILLUMINATE, FOUND SWITCH, LIGHT PANEL ASSY FOUND BAD GROUND IN PANEL REPAIRED OPS CHECKED GOOD IAW 33-13-00.SDR UIEA2013110400549Lamp · inoperativeMOST FWD STEWARDESS CENTER EMERGENCY LIGHT SEGMENT INOPERATIVE. REPLACED LAMP IAW AMM 33-51-10.SDR UIEA2013110300547Bulb · inoperativeL-2 EXTERIOR EMERGENCY EXIT FLOOD LIGHT INOPERATIVE. REPLACED LAMP, OPS CHECKED OK IAW MM 33-51-06.SDR UIEA2013101700525Shutoff Valve · inoperativeRIGHT ENGINE BLEED DID NOT OPEN AFTER START. R & R NR 2 ENGINE PRSOV, IAW AMM 36-11-07, OPS CHECKED GOOD.SDR UIEA2013101500520Bleed Air Sys · malfunctionedRT ENGINE BLEED DID NOT OPEN AFTER START. OPENSDR UIEA2013100900515Warning Light · false activationLEFT PACK OVERTEMP ON CLIMBOUT. PERFORMED BITE IAW FIM 21-51, FT 803, TEST PASSED, OPS CHECKED NORMAL.SDR UIEA2013100500513Anti-Skid Valve · faultedANTI-SKID STATUS MESSAGE DISPLAYED, NORMAL ANTI-SKID ALSO DISPLAYED, BITE CHECK SHOWS VALVE FAULT, REPLACED NR 2 ANTI-SKID VALVE IAW AMM 32-42-03, LEAK AND OPS CHECKED GOOD.SDR UIEA2013081900453Oxygen Bottle · emptyTWO PORTABLE OXYGEN CYLINDERS DEPLEATED. SERVICED OXYGEN CYLINDERS IAW GMM 3-28-3.SDR UIEA2013080100420Transducer · failedAPU SURGE BLEED DUCT BLOWN, AND APU BLEED AIR INOPERATIVE. R & R PT TRANSDUCER IAW AMM 49-53-02, OPS CHECKED GOOD. R & R APU SURGE BLEED DUCT IAW AMM 49-53-01. OPS CHECKED. LEAK CHECKED GOOD.SDR UIEA2013073000417Bleed Air Sys · inoperativeAPU BLEED AIR FUNCTION INOPERATIVE.SDR UIEA2013071800400Connector · looseAFT GALLEY EMERGENCY LIGHT INOPERATIVE. SEATED CONNECTOR IAW AMM 33-51-05, OPS CHECKED GOOD.SDR UIEA2013071700390Packing · defectiveAPU BLEED DUCT IS LEAKING AT LOWER SIDE OF APU COMPRESSOR AT FLANGE ATTACH POINT. REPLACED DEFECTIVE PACKING WITH A SERVICABLE PACKING IN PNEUMATIC DUCT AT LOWER SIDE OF APU COMPRESSOR AT FLANGE ATTACH POINT. LEAK CHECKED GOOD IAW AMM 49-53-05.SDR UIEA2013071700384Seal · leakingRT A/C PACK HAS TWO AIR LEAKS AT THE HEAT EXCHANGER DUCTS. REPOSITIONED CLAMP AND TORQUED AT UPPER INBD HEAT EXCHANGER POSITION AND REPLACED SEAL AT INBD CONDENSOR TO HEAT EXCHANGER DUCT, LEAK CHECKED GOOD IAW AMM 21-51-10.SDR UIEA2013071700392Pump · failedRT ENGINE HYD PRIMARY PUMP HAS NO PRESSURE INDICATION. PERFORMED A TEST OF THE RT RESERVOIR PRESSURIZATION SYSTEM. OPS CHECKED GOOD IAW AMM 29-12-00.SDR UIEA2013071700393Case · crackedNR 2 ENGINE PRECOOLER CASE IS CRACKED AT LOWER SIDE AT OUTLET WELDED AREA. REPLACED NR 2; ENGINE PRECOOLER TO BE INSTALLED IAW AMM 36-11-15.SDR UIEA2013071700394Light · malfunctionedCOCKPIT EMERGENCY LIGHT ABOVE DOOR WHEN EXITING STAYS ON. R & R COCKPIT EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR UIEA2013071700395Lamp · burned outEMERGENCY FLOOR PATH LIGHTING HAS MANY SECTIONS NOT WORKING. REPLACED LAMP AND RESCURED FLOOR PATH LIGHTING IAW AMM 33-51-10. OPS CHECKED OK.SDR UIEA2013071700396Lens · wrong partFWD CABIN EMERGENCY PATH LIGHTING LENS COLORED WITH RED MARKER. REPLACED FWD CABIN EMERGENCY PATH LIGHTING LENS IAW AMM 33-51-10.SDR UIEA2013071700397Bulb · burned outR1 DOOR EXIT SIGN HAS BURNED OUT LIGHT BULB. REPLACED BULB IAW AMM 33-51-03, OPS CHECKED GOOD.
Back to N642GT