N716SW, cancelled Nov 13, 2024
Service difficulty reports · 274
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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 SWAA2016123010882Lens · missingEXIT LIGHT LENS MISSING AT ROW 6 ABC. INSTALLED A NEW LENS IAW MM.SDR SWAA2016051851914Connector · brokenR2 DOOR EMER EXIT LIGHT CONNECTOR BROKEN. R & R CONNECTOR IAW AMM.SDR SWAA2016051751874Splice · corrodedFLOOR RAIL SPLICE STRAP CORRODED AT BS 767+5, LBL 3. R & R SPLICE IAW EA.SDR SWAA2016051851913Structure · corrodedL2 INNER LOWER CHORD CORRODED. R & R CHORD IAW DWG & SRM.SDR SWAA0235050152022Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, BETWEEN RBL 50 TO LBL 50. R & R FLOORBEAM IAW SRM & EA.SDR SWAA2016051751873Pressure Panel · crackedWHEEL WELL SPAR VERTICAL PRESS WEB CRACKED AT BS 663, RBL 40. REPAIRED WEB IAW SRM.SDR SWAA2016051651842Structure · corrodedR2 DOOR LOWER INNER CHORD CORRODED. R & R CHORD IAW SRM & DWG.SDR SWAA2016051251737Support Fitting · crackedRIGHT WING UPPER TE PANEL SUPPORT CLIP CRACKED INBD SIDE OF DEFLECTION ROLLER RIB, RSS 280, 15" AFT OF REAR SPAR. R & R CLIP IAW SRM.SDR SWAA2016050251464Support Bracket · crackedLEFT WING CTR SUPPORT BRACKET FOR UPPER TE WING PANEL CRACKED, AT LOWER MOUNT BOLT HOLE, RSS 270. R & R BRACKET IAW SRM & DWG.SDR SWAA2016050251463Support · crackedRIGHT WING UPPER TE PANEL, SEAL RETAINER SUPPORT CRACKED AT RSS 273, 18" AFT OF REAR SPAR. R & R SUPPORT IAW DWG.SDR SWAA2016050451554Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED AT BS 694, RBL 63. R & R CHORD IAW SRM & DWG.SDR SWAA2016050451553Crease Beam · corrodedCREASE BEAM CHORD CORRODED, BETWEEN BS 720 - 725, BETWEEN LBL 63 - 65. R & R CHORD IAW SRM & DWG.SDR SWAA2016050451552Web · corrodedFORWARD CARGO SUB THRESHOLD WEB CORRODED, BETWEEN BS 440 - 493, BETWEEN RBL 24 - 28. R & R WEB IAW SRM & DWG.SDR SWAA2016050351502Nut Plate · corrodedAFT CARGO DOOR FRAME NUTPLATE STRIP CORRODED AT BS 793, STRINGER 25R, FWD LOWER CORNER. R & R STRIP IAW SRM & DWG.SDR SWAA2016042051115Pressure Deck · corrodedLEFT PRESS DECK ABOVE MLG WW INNER CREASE BEAM CHORD CORRODED, BETWEEN BS 710 - 714, LBL 64. REPAIRED CHORD IAW SRM.SDR SWAA2016051651841Shear Web · corrodedAFT PAX COMPARTMENT, FLOOR STRUCTURE SHEAR WEB CORRODED AT BS 1014, LBL 40. R & R SHEAR WEB IAW DWG & SRM.SDR SWAA2016051651840Structure · corrodedAFT PAX COMPARTMENT, FLOOR STRUCTURE CORRODED AT BS 949.5, RBL 44. R & R STRUCTURE IAW SRM & DWG.SDR SWAA2016051651839Floorbeam · corrodedAFT PAX COMPARTMENT, FLOOR STRUCTURE CORRODED AT BS 966.5, RBL 24. REPAIRED FLOORBEAM IAW SRM & EA.SDR SWAA2016051651838Floor Support · corrodedAFT PAX COMPARTMENT, FLOOR STRUCTURE FLOOR SUPPORT, UPPER SURFACE CORRODED AT BS 970.5, RBL 14. R & R STRUCTURE IAW SRM & DWG.SDR SWAA2016051651837Shear Web · corrodedFLOOR STRUCTURE SHEAR WEB CORRODED, BETWEEN BS 986.5 - 1016, BETWEEN RBL 37 - 47. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2016051351769Angle · corrodedAFT PAX COMPARTMENT FLOOR STRUCTURE ANGLE CORRODED AT BS 945.5, LBL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2016051051690Floor Support · corrodedAFT PAX COMPARTMENT FLOOR SUPPORT CORRODED AT BS 961.5, RBL 17. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016051051689Floor Support · corrodedAFT PAX COMPARTMENT FLOOR SUPPORT CORRODED AT BS 99.5, RBL 7. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016051051688Floor Support · corrodedAFT PAX COMPARTMENT FLOOR SUPPORT CORRODED AT BS 958.5, RBL 14. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016050451551Intercostal · corrodedINTERCOSTAL CORRODED AT BS 300, RBL 10. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016050251462Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, RBL 39, UPPER SURFACE. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2016051851912Support · corrodedFLOOR SIDEWALL SUPPORT CORRODED AT BS 865, LBL 12. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016051651836Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 847 - 852, RBL 6. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016051651835Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 767 - 771, RBL 6. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016050551573Crease Beam · corrodedFORWARD ENTRY DOOR CREASE BEAM CORRODED. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2016050451550Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 344 - 328, LBL 12. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016042951416Fairing · crackedLEFT WING TO BODY FAIRING 195BL TOP ROW OF SCREW HOLES CRACKED. REPAIRED FAIRING IAW SRM.SDR SWAA2016042851406Strip · corrodedAFT CARGO BAY FWD SCUFF PLATE TO FLOOR CAP CORRODED AT BS 787, RBL 20. R & R CAP STRIP IAW SRM & DWG.SDR SWAA2016042751380Intercostal · crackedFLOORBEAM INTERCOSTAL CRACKED BETWEEN BS 308 - 328, LBL 47. R & R INTERCOSTAL IAW SRM.SDR SWAA2016042551284Fairing · crackedLEFT WING TO BODY FAIRING 195CL AFT LOWER CORNER PATCH CRACKED. REPAIRED FAIRING IAW SRM.SDR SWAA2016042551283Intercostal · crackedINTERCOSTAL BETWEEN FLOORBEAMS CRACKED, BETWEEN BS 277 - 294, BL 0. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016052352021Frame · crackedFRAME CORRODED AT BS 787, BETWEEN LBL 24 - 28. R & R FRAME IAW ER & EA.SDR SWAA2016051951921Light · damagedG4 AFT GALLEY EMER EXIT LIGHT DAMAGED. R & R LIGHT IAW AMM.SDR SWAA2016051851911Threshold · corrodedSUB THRESHOLD WEB CORRODED, BETWEEN BS 802 - 835, RBL 25. R & R THRESHOLD IAW SRM & DWG.SDR SWAA2016051851910Light · damagedAFT LAVATORY EMER EXIT & SALIDA LIGHT DAMAGED. R & R LIGHT IAW AMM.SDR SWAA2016051751877Shear Web · corrodedR2 DOOR AT AFT END SHEAR WEB CORRODED AT BS 986, RBL 46. R & R WEB IAW SRM & DWG.SDR SWAA2016051751872Frame · corrodedFRAME CORRODED AT BS 947, LBL 9. REPAIRED FRAME IAW DWG & SRM.SDR SWAA2016051751871Seat Track · corrodedFLOOR TRACK CORRODED, BETWEEN BS 787 - 867, RBL 14. R & R TRACK IAW SRM & DWG.SDR SWAA2016051751870Seat Track · corrodedFLOOR TRACK CORRODED AT BS 727D+5, LBL 17. R & R TRACK IAW DWG & SRM.SDR SWAA2016051751869Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 727D - 767, RBL 20. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016051651834Floorbeam · corrodedFLOOR RAIL BEAM CORRODED AT BS 727D+5, LBL 12. R & R FLOORBEAM IAW SRM & DWG.SDR SWAA2016051651833Floorbeam · corrodedFLOOR RAIL BEAM CORRODED AT BS 727D+5, LBL 8. R & R FLOORBEAM IAW SRM.SDR SWAA2016051651832Floorbeam · corrodedFLOOR RAIL BEAM CORRODED AT BS 727D+5, LBL 3. REPAIRED FLOORBEAM IAW EA.SDR SWAA2016051651831Floorbeam · corrodedFLOOR RAIL BEAM CORRODED AT BS 727D+5, RBL. R & R FLOORBEAM IAW SRM & DWG.SDR SWAA2016051651830Floorbeam · corrodedFLOOR RAIL BEAM CORRODED AT BS 727D+5, RBL 8. REPAIRED FLOORBEAM IAW EA.
Back to N716SW, cancelled Nov 13, 2024