N361GT, cancelled Nov 2, 2023
Service difficulty reports · 25
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 = 'N361GT' AND deregistration_id = 'N361GT-2023-11-02' 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 = 'N361GT' AND deregistration_id = 'N361GT-2023-11-02' 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 Q2SA201920000004Power Supply · inoperativeEMERGENCY EXIT LIGHTS IN OVERHEAD BINS (SEAT 16 AND 20) INOP - REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-51-962-016 - OPS CHECK GOOD PER AMM 33-51-51-712-007.SDR Q2SA201921000003Power Supply · inoperativeLT OVERWING EXIT LIGHTS INOP (BOTH) - REMOVED AND INSTALLED NEW POWER SUPPLY P/N BP57-3, S/N 49196 AND OPS CHECK GOOD IAW AMM 33-51-51-962-016.SDR Q2SA2019022800137Battery Pack · dischargedLT FWD OVERWING EMERGENCY LIGHT INOP. REMOVED BATTERY POWER SUPPLY P/N BP57-3 S/N 28295. INSTALLED P/N BP57-3, S/N 1836.SDR Q2SA201902280036Floorbeam · corrodedFLOOR STATION 328 ON THE RH SIDE HAS CORROSION ON FLOOR BEAM UPPER FLANGE.SDR Q2SA2019022800004Web · corrodedLT MLG DOOR UPPER SKIN PANEL AFT CLOSEOUT WEB CORRODED.SDR Q2SA2019022800054Angle · corrodedCORROSION AT STA 500 LT SIDE AT NUTPLATES ON ZEE ANGLE.SDR Q2SA2019022800098Angle · corrodedCORROSION ON ZEE ANGLE, LT SIDE BETWEEN STA 380 AND 500G AT NUTPLATES.SDR Q2SA2019022800097Angle · corrodedCORROSION ON ZEE ANGLE LT SIDE BETWEEN STA 490 AND 500 AT NUTPLATES.SDR Q2SA2019022800138Cargo Track · corrodedFWD CARGO CARGO TRACK AT STA 500G LT SIDE CORRODED.SDR Q2SA2019022800092Cargo Track · corrodedCORROSION AT NUT PLATE ON CARGO TRACK LT SIDE STA 500G.SDR Q2SA2019022800062Angle · corrodedCORROSION RT SIDE ON ZEE ANGLE AT NUTPLATES BETWEEN STA 500A TO 500B.SDR Q2SA2019022800104Floor Support · corrodedCORROSION AROUND NUTPLATES ON FLOOR SUPPORT LBL 20 FROM STA 847 TO 947.5.SDR Q2SA2019022800122Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT RBL 20 BETWEEN STA 727G AND 787.SDR Q2SA2019022800090Cargo Track · corrodedCORROSION CENTER FLOOR TRACK AT NUTPLATE BETWEEN STA 500G AND 500F.SDR Q2SA2019022800133Intercostal · corrodedFWD CARGO STA 500C TO 500D LT INTERCOSTAL CORRODED.SDR Q2SA2019022800135Intercostal · corrodedFWD CARGO STA 500F TO 500G, LT INTERCOSTAL CORRODED.SDR Q2SA2019022800118Floor Support · corrodedCORROSION AROUND NUTPLATES AT RBL 20 BETWEEN STA 727E AND 727G.SDR Q2SA2019022800043Angle · corrodedZEE ANGLE LT SIDE, CORROSION BETWEEN STA 500F TO 500G.SDR Q2SA2019022800045Anchor Fitting · corrodedCORROSION AT STA 500E HOLD DOWN TANG, LT SIDE.SDR Q2SA2019022800035Support · corrodedVERTICAL RT TE VERTICAL SUPPORT BELOW LOWER BALANCE WEIGHT BAY CORRODED.SDR Q2SA2019022800044Anchor Fitting · corrodedSIDEWALL PANEL HOLD DOWN TANG AT STA 500F LT SIDE HAS CORROSION.SDR Q2SA2019022800129Intercostal · corrodedFWD CARGO STA 500C TO 500D RT INTERCOSTAL CORRODED.SDR Q2SA2019022800056Angle · corrodedCORROSION UNDER NUTPLATE LT SIDE BETWEEN STA 500G AND 500F ON ZEE ANGLE.SDR Q2SA201930000046Structure · dentedDENT FOUND ON HORIZONTAL INNER FUSELAGE LOWER DECK STRUCTURE DURING LH HORIZONTAL SLIDER REMOVAL.SDR Q2SA201902280034Channel · corrodedAT L1 DOOR UNDER FLOOR PANEL 2337, MOP SEAL HAS CORROSION IN SEVERAL LOCATIONS.
Back to N361GT, cancelled Nov 2, 2023