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 UIEA2015012600018Support Bracket · corrodedFUSELAGE STATION 830 AFT SUPPORT FOR KEEL BEAM PANEL 139AO HAS CORROSION AROUND FASTENER HOLES. R & R AFT SUPPORT TEE BRACKET IAW AMM 51-40-05.SDR UIEA2015012600017Plate · corrodedFUSELAGE STATION 786 FWD SUPPORT FOR PANEL 139AO HAS CORROSION AROUND FASTENER HOLES. UPPER & LOWER SURFACES DI 34 DOT 51, REMOVED CORRODED PLATE, FABRICATED NEW & INSTALLED IAW AMM 51-40-05.SDR UIEA2015012600016Sidewall Panel · bowedLAVATORY AC 3 HAS A BOWED OUT SIDEWALL, INBD, AFT LOWER. R & R, REINSTALLED LAVATORY AC 3 IAW AMM 25-41-04.SDR UIEA2015012600015Mount · corrodedLAVATORY AC 4 HAS AFT MOUNT CORRODED. REMOVED & REINSTALLED AFT LAVATORY AC-4 IAW AMM 25-41-04. REPLACED LAVATORY AC-4 MOUNTS.SDR UIEA2015012600014Light · inoperativeEXIT SIGN NEAR FLOOR AT DOOR L2 SEVERAL BULBS INOPERATIVE. REPLACED BULBS IN EXIT SIGN NEAR FLOOR AT L2 DOOR IAW AMM 33-51-09. LIGHT OPERATIONS CHECKED GOOD.SDR UIEA2015012600013Slide · defectiveL4 DOOR SLIDE APPEARS TO BE COMING APART. REMOVED L4 DOOR SLIDE & INSTALLED SERVICEABLE ONE IAW AMM 25-66-01.SDR UIEA2015012600012Door · lack of lubeLAVATORY H WASTE BIN DOOR DOES NOT CLOSE CORRECTLY. LUBRICATED LAVATORY H WASTE BIN DOOR IAW AMM 12-21-00.SDR UIEA2014122400662Control Valve · malfunctionedLEFT PACK LIGHT NOT ILLUMINATED WITH PACK OFF. REPLACED LT PACK FLOW CONTROL VLV IAW AMM 21-51-01 401. TESTED OK.SDR UIEA2014122600664Shutoff Valve · malfunctionedRIGHT ENG BLEED SWITCH LIGHT OFF, LIGHT FAILS TO ILLUMINATE ON SHUTDOWN. LIGHT IS OK, MULTIPLE OCCASIONS. R & R PRSOV. RUN OPERATIONS CHECKED GOOD IAW AMM 36-11-09.SDR UIEA2014122200654Connector · dirtyLEFT PACK CTL VLV REMAINS OPEN WITH SWITCH OFF. PACK CONTINUES TO RUN, HAS OCCURRED ON NUMEROUS STARTS. VERIFIED THAT VLV MOVES TO COMMANDED POSITION. REMOVED, CLEANED & RECONNECTED CLOSED POSITION SWITCH ASSEMBLY ELEC CONNECTOR. TESTED IAW AMM 21-51-01 40SDR UIEA2014122200655Warning System · false activationON PREFLIGHT, STATUS MSG, AFT EQ EXH FAN 1. ACCOMPLISHED EQUIP COOLING SYS ADJUSTMENT & TEST ISW AMM 21-58-00 501. PLACARD REMOVED, NO STATUS MSG. ACFT RESTORED TO NORMAL CONFIG. OPERATIONS CHECKED NORMAL.SDR UIEA2014120900645Charger · inoperativeEMERGENCY LIGHT EXIT SIGN L306 RT SIDE OF CABIN AFT BEFORE R3 DOOR DOESN’T TEST. R & R BATTERY CHARGER IAW AMM 33-51-07. OPERATIONS CHECKED GOOD.SDR UIEA2014112800614Cover · crackedEMERGENCY FLOOR LIGHT TRACK COVER CRACKED ON RT SIDE CABIN AT SEATS 5K & H & 6K & H. R & R FLOOR LIGHT TRACK COVER IAW AMM 33-51-10-002-112.SDR UIEA2014112800613Light · brokenEMERGENCY FLOOR LIGHT AT LT CABIN POSITION SEAT 4C & A BROKEN. R & R BROKEN FLOOR LIGHT IAW AMM 33-51-10-962-063.SDR UIEA2014112300605Fuel Filter · defectiveLEFT ENG FUEL FILTER STATUS MSG. ACCOMPLISHED FIM 73-11 FT 803, NO CONTAMINATION. REPLACED FUEL FILTER IAW AMM 73-11-02 401. COMPLIED WITH POWER PLANT TEST 71-00-00 501 TEST 2, NO LEAKS.SDR UIEA2014112100602Warning System · false activationSTATUS MSG ON DESCENT CABIN ALT AUTO 2. ACCOMPLISHED FIM 21-31 FT 803. TESTED OK NO FAULTS.SDR UIEA2014111700596Warning System · false activationON CLIMB EICAS ADVISORY LT ENG PRV STATUS MSG. CLEARED STATUS & OPERATIONS CHECKED IAW AMM 36-11-18 413-415. OPERATIONS CHECKED OK.SDR UIEA2014111300594Warning System · false activationRIGHT ENG PRV STATUS MSG ON ENG START. DURING DDG DEACTIVATION PROCEDURE, MSG EXTINGUISHED, REACTIVATED PRV & ACCOMPLISHED OPERATIONS. CHECKED IAW AMM 36-11-18 413 F - G PASS, MSG DID NOT RECUR.SDR UIEA2014102300503Warning System · activatedIDG OUT TEMP MX MSG. IN WORK ACFT IS IN A CHECK.SDR UIEA2014101800496Clamp · looseAPU BLEED AIR LOW 15 PSI. TIGHTENED CLAMP ON SURGE VLV.SDR UIEA2014101800499Tru · faultyAPU FAULT ON START AFTER LANDING. APU TRU DEACTIVATED. REPLACED APU STARTING TRU. TESTED IAW AMM 24-32-04 401. TESTED OK, ACFT RESTORED TO NORMAL CONFIGURATION.SDR UIEA2014101700492Control Valve · malfunctionedRIGHT PACK INOPERATIVE LIGHT. REPLACED PACK TEMP CONTROL VLV.SDR UIEA2014101300490Fuel Filter · faultedSTATUS MSG DISPLAY RT ENG FUEL FILTER. R & R RT ENG FUEL FILTER IAW MM 73-11-02 601. OPERATIONS CHECKED NORMAL.SDR UIEA2014101300491Light · out of positionRIGHT EMER LIGHTS FROM K5 TO K10 NOT ILLUMINATING DURING TEST. REPOSITIONED K10 LIGHT ASSEMBLY IAW 33-51-16. OPERATIONS CHECKED NORMAL.SDR UIEA2014100600477Fire Loop · faultyAPU FIRE LP 1 EICAS STATUS MSG NOTED UPON LANDING. R & R APU UPPER FIRE LOOP IAW MM 26-15-02. OPERATIONS CHECKED OK.SDR UIEA2014100600472Fire Warning · false activationAPU FIRE LP1 MSG CAME ON. PERFORMED OPERATIONS CHECK IAW AMM 26-15-00, NO FURTHER MSGS.SDR UIEA2014100300469Warning System · false activationRIGHT ENG CONTROL STATUS MSG. PERFORMED FIM 73-21 FT 878, BITE PIMU IAW 71-01 FT 810. MSG CLEARED. PERFORMED OHMS CHECK OF ECU P 7 & 8, CHECKED WITHIN LIMITS. PERFORMED GND TEST & ENG RUN, NO FAULT NOTED.SDR UIEA2014091500440Window · crackedCAPTAINS FWD WINDOW SHATTERED & CRACKED DURING CRUISE. R & R CABIN L1 WINDOW IAW AMM 56-11-01 & 30-41-00. OPERATIONS CHECKED NORMAL.SDR UIEA2014092000450Warning System · false activationSTATUS MSG R ENG PRV. ACCOMPLISHED ENG RUN ERASED STATUS MSG. PNEUMATICS TESTED OK IAW AMM 36-11-00/501, NO MSGS GENERATED. ACCOMPLISHED FIM 36-20 FT 804 FIG 104. VERIFY TEST, NO FAULTS PRESENT.SDR UIEA2014081300399Circuit Card · faultyAPU FIRE LP 1. R & R APU FIRE WARNING CONTROL CARD IAW AMM 26-15-00. OPERATIONS CHECKS COMPLIED WITH.SDR UIEA2014080500361Light · inoperativeFLOOR LIGHTS BETWEEN DOOR L1 & SEAT 2AC INOPERATIVE. EMER PATHWAY LIGHTING. REPAIRED IAW AMM 33-51-10-93.SDR UIEA2014080500353Light · inoperativeLEFT MID SLIDE LIGHT INOPERATIVE. REPLACED LT MID SLIDE BULB IAW AMM 33-51-06-902-082. OPERATIONS CHECKED GOOD IAW AMM 33-51-06-862-083.SDR UIEA2014080500354Wire · brokenFLOOR EMER LIGHT BETWEEN DOORS L1 & R1 INOPERATIVE. REPAIRED BROKEN WIRES IAW AMM 33-51-10.SDR UIEA2014080500355Gasket · unknownAPU IGNITER PLUG REQUIRES NEW GASKET. REPLACED APU IGNITER PLUG GASKET WITH NEW GASKET IAW AMM 49-41-02.SDR UIEA2014072500347Idg · inoperativeRIGHT GEN INOPERATIVE. TRANSFERRED TO DMI 49937. R & R RT IDG IAW AMM 24-11-01. OPERATIONS CHECKED & LEAK CHECKED IAW AMM 24-11-00, MEL CLEARED.SDR UIEA2014072300340Gcu · failedRIGHT GENERATOR DRIVE EICAS MESSAGE. ACCOMPLISHED RT GENERATOR DRIVE QRH PROCEDURE. RAN RT ENGINE IDG FREQS ARE 392 GEN CONTINUED TO DISCONNECT. REMOVED AND REPLACED GENERATOR CONTROL UNIT IAW AMM 24-22-02, OPS CHECKED OK.SDR UIEA2014071300326Heater · crackedRIGHT PACK OVERHEAT, REHEATER CRACKED. R & R PACK REHEATER IAW MM 21-51-07, OPS CHECKED OK.SDR UIEA2014070500315Warning System · false activationRIGHT BLD DUCT LEAK, EICAS MSG. PERFORMED OPERATIONAL CHECK OF WING & BODY DUCT LEAK DETECTION IAW MM 26-18-00, OPERATES NORMAL, NO DEFECTS NOTED.SDR UIEA2014070200309Smoke Detector · false activationSMOKE DETECTOR ON LAVATORY A3 ACROSS FROM THE L4 JUMP SEAT ACTIVATES INTERMITTENT IN FLIGHT. R & R SMOKE DETECTOR IAW MM 26-13-01, OPS NORMAL.SDR UIEA2014062900252Ecu · failedAPU BLEED INOPERATIVE. R & R APU ECU IAW MM 49-61-05. OPS CHECKED NORMAL.SDR UIEA2014061800237Door · damagedVIBRATION & RT PACK OVERHEAT EICAS MESSAGE. PASSING 10,000 FT & ACCELERATING. DIVERTED AND LANDED. INSPECTED ACFT & FOUND DUE TO IMPROPER DOOR PROCEDURES, BOTH PACK BAY ACCESS DOORS DAMAGED WITH ASSOCIATED HARDWARE & WIRING DAMAGED. PERFORMED REPAIR OF WISDR UIEA2014051900210Slide · low pressureR1 DOOR SLIDE REQUIRES REPLACEMENT FOR LOW PRESS. R & R ENTRY SERVICE DOOR ESCAPE SLIDE PACK AT R1 DOOR IAW AMM 25-66-01.SDR UIEA2014051900209Elt · damagedELT BEHIND SEAT 37CA ANTENNA STRING IS BROKEN & UNRAVELED. INSTALLED NEW ELT BEHIND SEAT 37CA IAW AMM 25-63-00, 25-05-03.SDR UIEA2014051900208Plenum · delaminatedLEFT PACK RAM AIR EXIT HAS DELAMINATION IN DUCT. REMOVED & REINSTALLED LT PACK EXHAUST PLENUM IAW AMM 21-51-03. REPAIRED PLENUM IAW SRM 51-70-06, LEAK CHECKED GOOD.SDR UIEA2014051900207Clamp · brokenENG 2 D SUMP RETURN OIL LINE CLAMP IS BROKEN AT APPROX 7 O`CLOCK POSITION ABOVE THE LOWER RECOUP DUCT. R & R CLAMP AT 7 O`CLOCK POSITION ON D SUMP RETURN OIL LINE IAW AMM 20-11-00.SDR UIEA2014051900206Light · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE RT SIDE ROWS 26 - 30. REPLACED FLOOR EMERGENCY PATH LIGHTS AT ROWS 26 - 30 IAW AMM 33-51-10, OPERATIONS CHECKED SATISFACTORY.SDR UIEA2014051900205Carbon Seal · leakingRIGHT ENG CONSUMES MORE OIL THAN LT ENG. D SUMP AREA SUSPECTED TO BE AT FAULT. R & R SEALS AT D SUMP & STARTED CARBON SEALS. NO LEAKS NOTED AFTER ENG RUN IAW AMM 71-00-00.SDR UIEA2014051900204Window · damagedFL 41 BIRD STRIKE L1 OUTER PANE. R & R L1 WINDOW IAW AMM 56-11-01.SDR UIEA2014051900211Slide · low pressureL4 DOOR SLIDE REQUIRES REPLACEMENT FOR LOW PRESS. R & R ENTRY SERVICE DOOR ESCAPE SLIDE PACK IAW AMM 25-66-01 AT L4 DOOR POSITION.SDR UIEA2014051700196Seal · damagedRIGHT ENG CONSUMES MORE OIL THAN LT ENG & D SUMP AREA SUSPECTED TO BE AT FAULT. R & R D SUMP SEAL. R & R STARTER CARBON SEAL IAW AMM & EO 2016 2, NO LEAKS NOTED AFTER GND TEST IDLE.
Back to N642GT