N645SW, cancelled Nov 20, 2017
Service difficulty reports · 286
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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 SWAA2012062505267Stiffener · crackedSTIFFENER CRACKED AT BS 663, LBL 24.8. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012070305526Strap · corrodedSTRAP CORRODED BETWEEN BS 360 TO BS 380, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED DOUBLER IAW EA.SDR SWAA2012062805383Frame · crackedFRAME CRACKED AT BS 616, BETWEEN STR 7R TO STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012062605308Frame · crackedFRAME CRACKED AT BS 188 AT LEVEL FLOOR AREA IN FLIGHT CREW COMPARTMENT. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012062505270Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 3R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012062505266Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012062105141Tie Clip · crackedTIE CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.SDR SWAA2012062105140Tie Clip · crackedTIE CLIP CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.SDR SWAA2012062105129Fitting · crackedCLIP CRACKED AT BS 685+8, LBL 24.75. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062005108Fitting · crackedCLIP CRACKED AT BS 685+8, RBL 24. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012061504990Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061504962Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061504961Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061404939Tie Clip · crackedTIE CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061404938Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061204869Tie Clip · crackedTIE CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061204868Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012061204867Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062605330Skin · delaminatedLEFT WING NR 2 SLAT SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2012062505265Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062505264Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 21R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012062505263Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 19R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012061404936Fitting · crackedCLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012070205493Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB IAW EO AND EA.SDR SWAA2012062805382Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012062805381Skin · crackedLEFT WING NR 2 SLAT SKIN CRACKED BETWEEN WBL 329.75 TO WBL 355. REPAIRED SKIN IAW SRM.SDR SWAA2012062605262Splice · corrodedSPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 23L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012062505261Stringer · corrodedSTRINGER CORRODED BETWEEN BS 967 TO BS 986.5, STR 25L. REPAIRED STRINGER IAW SRM.SDR SWAA2012062505260Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012062505259Skin · crackedLEFT WING NR 1 SLAT SKIN CRACKED BETWEEN WS 505 TO WS 530. REPAIRED SKIN IAW SRM.SDR SWAA2012062505258Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 947.5, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062505257Angle · crackedWEB ANGLE CRACKED AT BS 380, STR 26R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012062505256Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 25L. REPAIRED FRAME IAW SRM.SDR SWAA2012062505255Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012062105139Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062105138Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STR 25L TO STR 24L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062105137Support Angle · corrodedSUPPORT ANGLE CORRODED AT BS 787, STR 25R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012070205492Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012070205491Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 54. REPAIRED CHORD IAW EA.SDR SWAA2012062805380Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW EA AND EO.SDR SWAA2012062605329Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EA.SDR SWAA2012062605307Fitting · crackedCLIP CRACKED AT BS 540, RBL 3. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062605306Fitting · crackedCLIP CRACKED AT BS 540, LBL 3. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062605305Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED STUB FRAME IAW EA.SDR SWAA2012062605304Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012062505254Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM 68.SDR SWAA2012062505253Tie Clip · corrodedTIE CLIP CORRODED AT BS 793.5, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012062505252Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012062505251Frame · corrodedFRAME CORRODED AT BS 907, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012061504960Cable · frayedR2 DOOR EMERGENCY ESCAPE SLIDE LATCH CABLE FRAYED. REMOVED AND REPLACED CABLE IAW AMM.
Back to N645SW, cancelled Nov 20, 2017