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 UIEA2013071700398Connector · damagedRT PRV WIRE FAULT DISPLAYED ON AIR SUPPLY BITE MODULE DURING TEST. R & R AIR SUPPLY BITE MODULE IAW 36-20-01. DID NOT FIX PROBLEM. FOUND PUSHED PIN AT D2378A. PIN B8 RESEATED PIN IAW 20-71-13.SDR UIEA2013071700399Exhaust Duct · damagedLEFT PACK EXHAUST DUCT HAS FIBERGLASS LINING COMING LOOSE INSIDE DUCT. REPAIRED LT PACK EXHAUST DUCT IAW AMM 21-51-23.SDR UIEA2013071700382Lamp · inoperativeL2 EXIT EMERGENCY LIGHT IS INOPERATIVE. R & R BULB AT L2 EMERGENCY EXIT LIGHT IAW AMM 33-51-06 OPS CHECKED GOOD.SDR UIEA2013071700381Stiffener · crackedENG 2, RT SIDE LOW PRESSURE TURBINE COOLING TUBE MANIFOLD STIFFENER CRACKED AT 5 O'CLOCK POSITION. R & R NR 2 ENGINE RT SIDE LOW PRESSURE TURBINE COOLING MANIFOLD IAW AMM 75-24-03.SDR UIEA2013071600372Lamp · burned outEMERGENCY LIGHT AFT OF LAV F IS BURNED OUT. R & R EMERGENCY FLOOR TRACK LAMP IAW AMM 33-51-10-962-077.SDR UIEA2013071600373Clamp · brokenAPU OIL COOLING FAN INLET DUCT CLAMP BROKEN. INSTALLED NEW FAN INLET DUCT CLAMP AT APU OIL COOLING FAN IAW AMM 49-51-02.SDR UIEA2013071600374Coupling · misinstalledAPU LT; LWR DUCT COUPLINGS INSTALLED INCORRECTLY AFT OF SURGE CONTROL VALVE. ADJUSTED APU LT; LWR DUCT COUPLINGS IAW AMM 49-53-01.SDR UIEA2013071600375Attach Bracket · crackedNR 2 ENGINE STARTER DUCT ROD ATTACH BRACKET CRACKED (LOWER ROD AT ENGINE ATTACH). R & R CRACKED BRACKET WITH NEW SERVICABLE BRACKET ON NR 2 ENG STARTER DUCT ATTACHING ROD IAW AMM 70-50-00 AND AMM 49-53-01.SDR UIEA2013071600376Panel · looseLAV F, INOPERATIVE 02 PANEL IN CEILING HELD IN PLACE WITH CARGO TAPE. CORNER FOUND TO HAVE LOOSE ATTACHING HARDWARE-TIGHTENDED HARDWARE IAW AMM 20-11-00.SDR UIEA2013071700377Line · dentedRT PYLON, TOPSIDE FUEL LINE HAS SHALLOW DENT (DENT MEASURES 0.027" DEEP FOUND TO BE WITHIN LIMITS IAW AMM 28-22-07).SDR UIEA2013071500366Indicator · missingLAV H MISSING TEMPERATURE INDICATOR ON WASTE DISPOSAL CHUTE (OUTSIDE). INSTALLED NEW TEMPERATURE INDICATOR ON WASTE DISPOSAL CHUTE (OUTSIDE) ON LAV H IAW AMM 11-35-02.SDR UIEA2013071700378Magnetic Plug · brokenNR 1 ENGINE STARTER MAGNETIC DRAIN PLUG ASSY BROKEN DURING REMOVAL. R & R NR 1 ENGINE STARTER MAGNETIC DRAIN PLUG ASSY W/REF AMM 12-22-02-603-054.SDR UIEA2013060700318Controller · inoperativeLEFT PACK BITE STATUS MESSAGE. R & R LT PACK CONTROLLER, OPS CHECK & BITE CHECK C/W. MESSAGE DID NOT REPEAT, OK FOR SERVICE. REF MM 21-51-00/601.SDR UIEA2013051300257Filter · cloggedCAPTAIN'S HSI WEATHER RADAR DISPLAY FAULT MESSAGE INTERMITTENT. PERFORMED SYS INSPECTION AND TEST IAW FIM 34-43-805 & AMP; 34-22-00 FIG103, FOUND CAPTAIN'S HSI INLET COOLING FILTER CLOGGED. ELEMENT SYS, SYSTEM OPS & GROUND TEST GOOD.SDR UIEA2013042900253Ignition Unit · faultyAPU DID NOT START - FAULT LIGHT ON. (R & R APU IGNITION UNIT IAW AMM 49-41-03. OPS CHECKS GOOD.)SDR UIEA2013041900248Anti-Skid Valve · inoperativeNR 8 BRAKE DEACTIVATED DUE TO ANTI-SKID EICAS MESSAGE IN FLIGHT MI 39201. R & R ANTI SKID VALVE IAW AMM 32-42-03.SDR UIEA2013041900247Bracket · looseLAVATORY E WASTE COMP DOOR CABLE BRACKET RIVETS LOOSE AND PULLED THROUGH. R & R 2 LOOSE RIVETS SECURING BRACKET IN PLACE REF SRM 51-40-02.SDR UIEA2013041900246Wastegate Valve · stickingLAV D WASTE FLAP STICKING AND WILL NOT RETURN TOP CLOSED POSITION. WASTE COMP. DOOR LATCH NOT WORKING AND LOOSE HARDWARE. CLEANED LAV D WASTE FLAP HINGE- OPS CHECK GOOD. REPLACED MISSING SCREWS IN TRASH DOOR AT LAV D AS NEEDED - DOOR OPS CHECK GOOD REF 25-0SDR UIEA2013041900245Panel · damagedLAVATORY C, F, & H WASTE CONTAINER UPPER SEAL PANEL MISSING HARDWARE. REPLACED HARDWARE ON LAV. C, F, & H WASTE CONTAINER UPPER SEAL PANEL IAW CMM 25-40-64.SDR UIEA2013041900244Connector · damagedFORWARD GALLEY CROSS AISLE FLOOR TRACK LIGHTS INOPERATIVE. FOUND BROKEN PIN ON FLOOR TRACK LIGHT ASSEMBLY AT FWD GALLEY. REPLACED PIN IAW SWPM 20-60-02, OPS CHECK GOOD.SDR UIEA2013041900243Cover · damagedEMERGENCY FLOOR PATH LIGHTING CONDUIT COVER DAMAGED. R & R EMERGENCY FLOOR PATH LIGHTING CONDUIT COVER AS REQUIRED - OPS CHECK GOOD, AMM 33-51-10.SDR UIEA2013041900242Reservoir · overservicedEICAS MX MESSAGE "RT HYD QTY O/FULL". REMOVED EXCESS HYD FLUID FROM RT HYD SYS RESERVOIR, OPS CHECKED GOOD AMM 12-12-01.SDR UIEA2013041900241Battery · inoperativeFLASHLIGHT LOCATED AT PILOTS SEAT INOPERATIVE. R & R EMERGENCY FLASHLIGHT BATTERY LOCATED AT PILOTS SEAT, CHECKED LIGHT AND RED FLASHING INDICATOR, OPS CHECKED GOOD AMM 25-64-00.SDR UIEA2013041900240Lamp · inoperativeEXTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE AT L1 AND R3 DOORS. R & R LAMPS AT L1 AND R3 EXTERIOR EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR UIEA2013040600174Gasket · tornFUEL LEAK AT NR 1 ENGINE. FOUND FUEL LINE BETWEEN HMU & TRANSMITTER GASKET TORN, R & R GASKET ON HMU TRANSMITTER LINE, LEAK CHECKED GOOD. REF AMM 73-33-00/001.SDR UIEA2013040200170Sump · leakingLT MAIN TANK FWD FUEL SUMP LEAKING. RESEATED LT MAIN SUMP IAW MM 12-11-03 NO LEAK NOTED.SDR UIEA2013040200169Bulb · burned outTWO BULBS BURNED OUT AT R3 EMERGENCY EXIT SIGN. REPLACED LAMPS IAW 33-51-00. OPS CHECKED OK.SDR UIEA2013040200167Bulb · inoperativeEMERGENCY LIGHT AT R2 DOOR INOPERATIVE. REPLACED LAMP, OPS CHECKED GOOD IAW AMM 33-51-00.SDR UIEA2013032100144Wire · disconnectedUPON ARRIVAL, MX INSPECTOR FOUND MID CABIN LT SIDE WHOLE ROW OF FLOOR EMERGENCY LIGHTS INOPERATIVE. FOUND WIRE DISCONNECTED FROM LIGHT MODULE, RE-INSTALLED WIRE, OPS CHECKED GOOD IAW MM 33-50-01.SDR UIEA2013032100143Warning Light · false activationAFTER ENGINE START, EICAS MESSAGE " RUDDER RATIO", BLOCK TURN-BACK. PERFORMED RUDDER RATIO OPS CHECK IAW AMM 27-21-00, SUB TASK 27-21-00-215, OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR UIEA2013031600131Apu · malfunctionedAPU FAULT ON START ATTEMPT AFTER LANDING. OPENSDR UIEA2013020700073Valve · inoperativeHMG VALVE INOPERATIVE. R & R HMG VALVE IAW AMM 24-25-03,, GROUND OPS CHECKED GOOD.SDR UIEA2013013100061Connector · disconnectedRT FORWARD EMERGENCY PATH LIGHTS HAS SECTION INOPERATIVE. CONNECTED EMERGENCY PATH LIGHT, OPS CHECKED GOOD IAW AMM 33-51-10-402-113.SDR UIEA2013013100042Pressure Switch · malfunctionedSTATUS MESSAGE "NR 1 ANTI-ICE VALVE" DISPLAYED. R & R NR 1 ANTI ICE VALVE SWITCH, IAW AMM 30-21-01, OPS CHECKS GOOD, ENGINE RUN OPS CHECKS GOO, IAW AMM 72-00-00.SDR UIEA2013013100044Oxygen Mask · leakingF/O OXYGEN MASK LEAKING. R & R OXYGEN MASK, LEAK CHECKED GOOD, REF AMM 35-11-54.SDR UIEA2013013000037Warning Message · illuminatedAT 5+30 HRS INTO FLT STATUS MESSAGE LT ENG TAI VALVE. PERFORMED FIM 30-21 FAULT TREE 805 PROCEDURES, ENGINE TAI OPS CHECK NORMAL.SDR UIEA2013012800029Lens · missingEMERGENCY TRACK LIGHT WIRE EXPOSED AT R2 DOOR. REINSTALLED LENS COVER IAW AMM 33-51-10, OPS CHECKED GOOD.SDR UIEA2013012800030Wire · exposedEMERGENCY TRACK LIGHT EXPOSED AT SEAT 43H. REPOSITIONED FLOOR TRACK COVER IAW AMM 25-27-01 OPS CHECK GOOD.SDR UIEA2013012800031Wire · exposedEMERGENCY TRACK LIGHT WIRE EXPOSED AT SEAT 4H. REPOSITIONED FLOOR TRACK IAW AMM 33-51-10, OPS CHECK GOOD.SDR UIEA2013012800032Wire · exposedEMERGENCY TRACK LIGHTING WIRE EXPOSED AT R2 DOOR. REINSTALLED LENS CAP IAW AMM 33-51-10, OPS CHECK GOOD.SDR UIEA2013012800033Wire · exposedEMERGENCY TRACK LIGHT WIRE EXPOSED AT SEAT 4H. REPOSITIONED FLOOR TRACK IAW AMM 33-51-10, OPS CHECK GOOD.SDR UIEA2013012800034Blade · nickedFAN BLADE NICKED NR 1 ENGINE. BLENDED AREA WITHIN LIMITS IAW AMM 72-31-02, FLORESCENT PARTICLE INSPECTION WITH NO ITEMS INDICATED.SDR UIEA2013010200002Shutoff Valve · intermittentLEFT ENGINE HPSOV ILLUMINATED INTERMITTENTLY DURING ALL PHASES OF FLIGHT. R & R LT ENGINE HPSOV IAW AMM 36-11-07, SYS BITE, LEAK CHECKED GOOD.SDR UIEA2013010100001Lens · missingEMERGENCY LIGHT LENS MISSING AT THE FOLLOWING POSITIONS; 25 A, 43A AND 43F.SDR UIEA2012122500563Flashlight · inoperativeR2 DOOR FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM 25-64-00. OPS NORMAL.SDR UIEA2012121600550Warning Light · false activationBEFORE DEPARTURE, FLIGHT CREW REPORTED EICAS MESSAGE " RT PACK TEMP" APPEAR. SYS OPS CHECKS GOOD IN STANDBY AND MANUAL.SDR UIEA2012121600552Control Valve · malfunctionedRT PACK TEMP CONTROL VALVE TRIPS ALERT DURING BITE TEST. REPLACED THE RT PACK TEMP CONTROL VALVE, IAW AMM 21-51-11. OPS CHECKED GOOD.SDR UIEA2012120500540Hose · leakingFIRST OFFICER`S O2 MASK STARTED LEAKING OXYGEN. REPLACED FLEXIABLE HOSE BELOW O2 MASK. OPS AND LEAK CHECKED GOOD. INSTALLED IAW AMM 20-10-10.SDR UIEA2012120300539Lens · brokenEMERGENCY LIGHT, ROW 4 BEHIND SEAT H, COVER BROKEN. RECONNECTED EMERGENCY LIGHT COVER, OPS CHECK GOOD, REF AMM 33-51-10.SDR UIEA2012112800536Filter · warning lightLT ENG FUEL FILT STATUS MESSAGE. R & R LT ENGINE FUEL FILTER, LEAK CHECK, OPS CHECKED GOOD, STATUS MESSAGE CLEARED. REF AMM 73-11-02-004-001-H00, ENG 71-00-00.
Back to N642GT