N779SW, cancelled Oct 28, 2024
Service difficulty reports · 189
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 = 'N779SW' AND deregistration_id = 'N779SW-2024-10-28' 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 = 'N779SW' AND deregistration_id = 'N779SW-2024-10-28' 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 SWAA2018082024373Floorbeam · corrodedAFT WET AREA FLOOR BEAM UPPER T-CHORD CORRODED AT BS 986.5, BETWEEN LBL 6 TO RBL 52. R&R TEE CAP PER SRM AND EA.SDR SWAA2018082024300Door Sill · corrodedR2 DOOR MOPSILL CORRODED BETWEEN BS 927 TO BS 986+9, WL 208. R&R MOPSILL IAW SRM AND DWG.SDR SWAA2018082024299Structure · corrodedL1 DOOR ZEE CHORD CORRODED BETWEEN BS 315 TO BS 340, LBL 63. R&R ZEE CHORD IAW SRM & DWG.SDR SWAA2018082024298Stiffener · crackedFORWARD SIDE OF BULKHEAD VAPOR BARRIER WEB STIFFENER CRACKED AT BS 663, BETWEEN LBL 6 TO LBL 31. R&R STIFFENER IAW SRM AND DWG.SDR SWAA2018081024164Angle · corrodedR2 DOOR MOPSILL SPLICE ANGLE CORRODED BETWEEN BS 1006 TO BS 1008, RBL 41. R&R ANGLE IAW SRM AND DWG.SDR SWAA2018081024163Door Sill · corrodedR1 DOOR MOPSILL CORRODED BETWEEN BS 291 TO BS 332, RBL 60. R&R MOPSILL IAW SRM AND DWG.SDR SWAA2018080924148Door Sill · corrodedR1 DOOR CHORD ATTACH TO MOPSILL CORRODED BETWEEN BS 300 TO BS 320, RBL 60. R&R CHORD IAW SRM AND DWG.SDR SWAA2018080824107Bulkhead · crackedLT WHEEL WELL VAPOR BARRIER LOWER WEB CRACKED FROM LOWER EDGE AT BS 663, LBL 12. REPAIRED WEB IAW SRM.SDR SWAA2018082024355Pressure Deck · crackedHORIZONTAL PRESSURE DECK CRACKED BETWEEN BS 673 TO BS 664, BETWEEN RBL 40 TO RBL 41. REPAIRED WEB IAW EA.SDR SWAA2018062522958Battery Pack · dischargedR1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK ASSEMBLY IAW MM.SDR SWAA2018041021024Keelbeam · crackedRIGHT WHEEL WELL KEEL BEAM CRACKED FORWARD LOWER WALL. REPAIRED THE KEEL BEAM PER MM.SDR SWAA2018022620058Light · inoperativeRT OFF-WING HATCH EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018021919832Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018021219581Slide · out of positionL2 DOOR SLIDE OUT OF POSITION. REPOSITIONED THE SLIDE IAW MT.SDR SWAA2018020819582Slide · brokenR2 DOOR EMERGENCY EVAC SLIDE LATCH BROKEN. R&R SLIDE PER MT.SDR SWAA2018011719059Skin · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED ON THE INBOARD LOWER SURFACE. R & R THE AFT FLAP IAW MM.SDR SWAA2018010918901Sliding Window · arcedCAPTAIN'S SLIDING WINDOW ARCED INFLIGHT. R & R THE L2 WINDOW ASSEMBLY IAW MT.SDR SWAA2017120418200Skin · crackedRT WING NR 6 SLAT LOWER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2017091916448Lens · looseOVERWING CENTER AISLE AFT EXIT SIGN LENS LOOSE. SECURED SIGN IAW AMM.SDR SWAA2017062814623Flap · delaminatedLT WING INBOARD MID-FLAP DELAMINATED ON OUTBOARD TRAILING EDGE. R&R MID FLAP IAW AMM.SDR SWAA2016121210424Sign · brokenRT OVERWING EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER MM.SDR SWAA2016101308743Battery · no testAFT RIGHT BATTERY FAILED TIME TEST. R & R BATTERY IAW AMM.SDR SWAA2016101308742Battery · no testFORWARD RIGHT BATTERY FAILED TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2016081154731Lamp · unsecureLEFT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 23 TO 24. RESEATED THE LAMP IAW AMM.SDR SWAA2016080854639Bulkhead · crackedRIGHT MAIN WHEEL WELL REAR SPAR VAPOR BARRIER, FIBERGLASS BULKHEAD CRACKED. REPAIRED BULKHEAD PER EA.SDR SWAA2016080254423Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R THE STRINGER CLIP IAW SRM.SDR SWAA2016080254444Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254443Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254442Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254441Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254440Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254439Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254438Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254437Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016080254436Frame · crackedFRAME CRACKED AT BS 380, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016080254422Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254421Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254420Frame · crackedFRAME CRACKED AT BS 727B, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254419Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016080254418Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016022549426Bracket · crackedLEFT & RIGHT AC BAY KEEL BEAM DUCT BRACKETS CRACKED. R & R BRACKET IAW SIP.SDR SWAA2015102045114Skin · crackedLEFT HORIZONTAL STABILIZER LOWER IN-SPAR SKIN, CRACKED IN SKIN ON INBD SIDE OF STAB STATION 184.70, RIB, 10.0" FROM AFT EDGE OF SKIN PANEL. REPAIRED SKIN IAW SRM.SDR SWAA2015110245579Window Frame · crackedRIGHT NR 3 WINDOW FRAME, NR 4 HOLE UP FROM BOTTOM CRACKED. REPAIRED WINDOW IAW ACO.SDR SWAA2015110245578Window Frame · crackedRIGHT NR 3 WINDOW FRAME, SECOND HOLE UP FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2015102945524Window Frame · crackedLEFT NR 3 WINDOW FRAME, NR 3 HOLE UP FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2015102845476Seat Track · crackedFORWARD SEAT TRACK FLANGE CRACKED AT BS 727B, RBL 24.75, AT OTBD AFT HOLE & BOTH FWD & AFT INBD HOLES. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015102845467Seat Track · crackedFORWARD SEAT TRACK FLANGE CRACKED AT BS 727B, RBL 45.5, AT BOTH FWD & AFT OTBD HOLES & BOTH FWD & AFT INBD HOLES. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015102745407Seat Track · crackedAFT SEAT TRACK, OTBD FLANGE CRACKED AT BS 727B, LBL 45.5. REPAIRED FLANGE IAW EA.SDR SWAA2015102645310Seat Track · crackedSEAT TRACK CRACKED AT BS 727B, LBL 24.75, AFT SEAT TRACK INBD & OTBD FLANGE HOLES. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015102645355Seat Track · crackedAFT SEAT TRACK INBD FLANGE CRACKED AT BS 727B, RBL 24.75. REPAIRED SEAT TRACK IAW EA.
Back to N779SW, cancelled Oct 28, 2024