N605SW, cancelled Jul 27, 2018
Service difficulty reports · 423
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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 SWAA2016021649097Skin · crackedRIGHT WING UPPER SKIN AT REAR SPAR HOLE, AT RSS 241.5, 3RD FASTENER ROW FWD 3.5" FROM TE. CRACKED INDICATION. REPAIRED SKIN IAW EA.SDR SWAA2016030749696Skin · crackedLEFT WING UPPER SKIN CRACKED, AT RSS 257, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030749695Skin · crackedLEFT WING UPPER SKIN CRACKED AT RSS 255.375, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030749694Skin · crackedLEFT WING UPPER SKIN CRACKED, AT RSS 251, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030749693Skin · crackedLEFT WING UPPER SKIN CRACKED AT RSS 249.5, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030749692Skin · crackedLEFT WING UPPER SKIN CRACKED AT RSS 239.34, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030449656Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, BETWEEN RSS 239 - 257, AFT FROM TE. REPAIRED SKIN IAW EA.SDR SWAA2016030249594Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, AT RSS 269, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030249593Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED AT RSS 268, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030249592Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, AT RSS 230.34, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030249591Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, AT RSS 248.875, 4TH ROW FROM AFT, 4.75" FROM TE. REPAIRED SKIN IAW EA.SDR SWAA2016021649103Spar · crackedRIGHT WING REAR SPAR UPPER CHORD, AT MLG AFT SUPPORT FITTING UPPER ROW, 4TH FROM OTBD FASTENER HOLE H CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2016020948800Spar · crackedLEFT WING REAR SPAR UPPER CHORD, UPPER ROW, 4TH FROM INBD, FASTENER HOLE CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2016020348630Support Fitting · crackedRIGHT WING REAR SPAR WEB AT MLG, AFT SUPPORT FITTINGS UPPER ROW, 5TH FROM OTBD, FASTENER HOLE CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2016011347969Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD UPPER ROW, 4TH FROM INBD FASTENER HOLE CRACKED. R & R SPAR IAW EA.SDR SWAA2016011347968Spar · crackedLEFT WING REAR SPAR, UPPER CHORD AT MLG AFT SUPPORT FITTING, UPPER INBD FASTENER HOLE CRACKED. REPAIRED SPAR IAW EA.SDR SWAA2015102145211Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD AT MLG, AFT SUPPORT FITTING LOWER ROW 2ND FROM OTBD FASTENER HOLE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015102145210Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD, LOWER ROW OTBD FASTENER HOLE SPLICE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015102145209Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD, UPPER ROW 3RD FROM INBD FASTENER HOLE CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2015042438881Bracket · crackedLEFT MLG MID DOOR AFT ATTACHMENT TO STRUT BRACKET CRACKED. R & R DOOR BRACKET IAW MM.SDR SWAA2015020436319Slide · looseR1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW SIP.SDR SWAA2015020236251Light · inoperativeFORWARD SERVICE DOOR EMER LIGHT INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2015012636070Slat · crackedRIGHT WING NR 5 SLAT LOWER LE 40 INCHES FROM OTBD END CRACKED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2015012636069Slat · crackedRIGHT WING NR 5 SLAT LOWER LE 2 INCHES FROM INBD END CRACKED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2015012135930Battery Pack · damagedLEFT EMER BATTERY PACK POWER SUPPLY CEILING OVERHEAD DAMAGED AT BS 967. R & R BATTERY PACK IAW AMM.SDR SWAA2015012035919Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 28R TO 28L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2015010735525Angle · crackedFLOOR STRUCTURE UPPER INTERCOSTAL ANGLE CRACKED BETWEEN BS 927 TO 947, BL 0. INSTALLED ANGLE IAW SRM.SDR SWAA2015012636068Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 807 TO 827. R & R WEB IAW SRM.SDR SWAA2015012636067Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 787 TO 787+6. R & R WEB IAW SRM & DWG.SDR SWAA2015012636066Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 767 TO 787. R & R WEB IAW SRM.SDR SWAA2015012636065Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO 480. R & R WEB IAW SRM.SDR SWAA2015012636064Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500C TO 500D. R & R WEB IAW SRM.SDR SWAA2015012636063Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO 500B. R & R WEB IAW SRM.SDR SWAA2015012636062Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 440 TO 460. R & R WEB IAW SRM & DWG.SDR SWAA2015012636061Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO 420. R & R WEB IAW SRM.SDR SWAA2015012636060Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380. R & R WEB IAW SRM.SDR SWAA2015012235977Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 380 - 400. R & R WEB IAW SRM & DWG.SDR SWAA2015012135929Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO 420. REPAIRED WEB IAW SRM.SDR SWAA2015012035918Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867. R & R WEB IAW SRM & DWG.SDR SWAA2015012035917Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO 400. R & R WEB IAW SRM & DWG.SDR SWAA2015012035916Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500B TO 500C. R & R WEB IAW SRM.SDR SWAA2015010935615Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 747 TO 767. R & R WEB IAW DWG & SRM.SDR SWAA2015010935588Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 747. R & R WEB IAW DWG & SRM.SDR SWAA2015010635499Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C. R & R WEB IAW DWG & SRM.SDR SWAA2015012636059Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, LBL 8. REPAIRED SUPPORT IAW EA & SRM.SDR SWAA2015012636058Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, LBL 3. REPAIRED SUPPORT IAW EA & SRM.SDR SWAA2015012636057Floor Support · corrodedFLOORBOARD SUPPORT STRUCTURE CORRODED BETWEEN BS 770 TO 775, RBL 8. REPAIRED SUPPORT IAW EA.SDR SWAA2015012636056Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN BS 770 TO 775, RBL 3. REPAIRED SUPPORT IAW EA.SDR SWAA2015012636055Shear Tie · corrodedFRAME LOWER ANGLE SHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 28R & 28L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2015011535774Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 667 TO 671, RBL 24.8. REPAIRED BEAM IAW ER & EA.
Back to N605SW, cancelled Jul 27, 2018