N365SW, cancelled May 11, 2016
Service difficulty reports · 325
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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 SWAA2012052404305Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012052304262Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360, STR 27L. REMOVED AND REPLACED SPLICE IAW SRM & DWG.SDR SWAA2012053104493Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN LBL 5 TO RBL 4. REPAIRED FRAME IAW EA AND EO.SDR SWAA2012052404304Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, STR 20L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012052404303Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 321, STR 20L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012052404302Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012052304261Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312, STR 20L. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012052104210Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED BETWEEN WBL 71.24 TO WBL 78. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012053004449Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 26L. REMOVED AND REPLACED TIE CLIP IAW EA AND EO AND SRM.SDR SWAA2012052404307Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012052904425Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT BS 727D, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2012052904424Channel · corrodedCHANNEL CORRODED AT BS 727D+5, RBL 3.00. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052904419Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012052904418Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT BS 727E, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2012052904417Skin · crackedLEFT WING 3 SPOILER SKIN CRACKED. REPAIRED SKIN IAW SRM & AMM.SDR SWAA2012052904416Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 727D TO BS 727E, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012052904414Stiffener · crackedSTIFFENER CRACKED AT BS 727, LBL 6. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012052504338Channel · corrodedCHANNEL CORRODED AT BS 859, LBL 3. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052504337Channel · corrodedCHANNEL CORRODED AT BS 859, LBL 8.10. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052504336Channel · corrodedCHANNEL CORRODED AT BS 859, LBL 12.50. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052504335Channel · corrodedCHANNEL CORRODED AT BS 727D+5, LBL 8.10. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052504334Channel · corrodedCHANNEL CORRODED AT BS 727D+5, RBL 8.10. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2012052404301Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 887, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012052404300Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052404299Fitting · crackedCLIP CRACKED AT BS 540, BETWEEN STR 28R AND STR 28L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012052404298Tie Clip · corrodedTIE CLIP CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060104540Skin · crackedSKIN CRACKED AT BS 334.5, STR 17L. REPAIRED SKIN IAW EA.SDR SWAA2012053104492Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW EO.SDR SWAA2012052904415Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012052904407Tie Clip · crackedTIE CLIP CRACKED AT BS 500B, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052904406Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052904395Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012052404297Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STR 27L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052404296Angle · crackedANGLE CRACKED AT BS 727B, RBL 45.5. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012052404295Fitting · crackedCLIP CRACKED AT BS 380, BETWEEN STR 25L AND STR 26L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2012052404294Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STR 23L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052404293Tie Clip · crackedTIE CLIP CRACKED AT BS 827, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052404292Tie Clip · crackedTIE CLIP CRACKED AT BS 727E, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012052304252Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012052104209Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0 AND RBL 24.5. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012051604047Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012051403957Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STR 20L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012051403956Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 19L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012053004453Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 666.5, LBL 24.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA2012052904423Skin · crackedSKIN CRACKED AT BS 520+2, STR 28L. REPAIRED SKIN IAW SRM.SDR SWAA2012032202488Beam · crackedLT STUB BEAM CRACKED AT STA 616 UPPER & LOWER HOLES COMMON TO FRAME INNER CORD. REMOVED AND REPLACED BEAM IAW EA & AMM.SDR SWAA117465Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727E+3, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA117223Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA117186Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY LT FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA117125Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME IAW SRM.
Back to N365SW, cancelled May 11, 2016