N705SW, cancelled Nov 7, 2024
Service difficulty reports · 216
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 = 'N705SW' AND deregistration_id = 'N705SW-2024-11-07' 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 = 'N705SW' AND deregistration_id = 'N705SW-2024-11-07' 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 SWAA2016061352810Skin · deformedL1 DOOR FUSELAGE SKIN LOWER HINGE CUTOUT DEFORMED. R & R SKIN IAW DWG AND SRM.SDR SWAA2016061352795Angle · crackedL1 DOOR INNER DOOR PAN CUTOUT REVEAL ANGLE CRACKED AT DOOR LOWER HINGE POINT. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041851044Power Supply · inoperativeRIGHT EMER LIGHTS INOPERATIVE, BETWEEN ROW 9 - 11. R & R POWER SUPPLY ASSEMBLY IAW AMM.SDR SWAA2016041851043Light · inoperativeR2 DOOR INTERIOR EMER EXIT SIGN LIGHT BULB INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016041851042Sign · inoperativeL2 DOOR INTERIOR EMER EXIT SIGN BULB INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2016041851041Sign · inoperativeRIGHT OVERWING INTERIOR EMER EXIT SIGN BULB INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2016041550972Battery Pack · dischargedMAIN ENTRY OVERHEAD EMER EXIT LIGHT INOPERATIVE AT LOCATION M1674. R & R BATTERY PACK IAW AMM.SDR SWAA2016041450908Housing · crackedOVERWING EXIT CTR CEILING EXIT SIGN HOUSING CRACKED. R & R SIGN HOUSING IAW AMM.SDR SWAA2016041350862Connector · brokenLEFT OVERHEAD BIN EMER EXIT LIGHT CONNECTOR BROKEN AT ROW 14. R & R CONNECTOR IAW WDM.SDR SWAA2016041450907Frame · corrodedFRAME CORRODED AT BS 303.9, LBL 55. REPAIRED FRAME IAW EA.SDR SWAA2016040750661Shear Web · damagedSHEAR WEB DAMAGED, BETWEEN BS 986 - 1016, LBL 40. R & R SHEAR WEB IAW SRM.SDR SWAA2016040750682Support Angle · corrodedFORWARD ENTRY DOOR THRESHOLD SUPPORT ANGLE ATTACHED TO MOP SILL CORRODED, BETWEEN BS 318 - 340. R & R ANGLE IAW DWG & SRM.SDR SWAA2016040450582Intercostal · crackedFORWARD CARGO BAY INTERCOSTAL CRACKED AT BS 500D, STRINGER 9R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016041450906Floorbeam · corrodedUPPER FLANGE OF FLOORBEAM CORRODED AT BS 987, BETWEEN LBL 29 - 35. REPAIRED FLOORBEAM IAW ER & EA.SDR SWAA2016041350861Angle · crackedANGLE CRACKED AT BS 295, RBL 56. REPAIRED ANGLE IAW EA.SDR SWAA2016041150739Shear Web · corrodedSHEAR WEB CORRODED, BETWEEN BS 986 - 1016, RBL 41. R & R SHEAR WEB IAW SRM.SDR SWAA2016040650654Floorbeam · corrodedFLOORBEAM ANGLE ASSEMBLY CORRODED AT BS 967, RBL 42. REPAIRED ANGLE IAW SRM.SDR SWAA2016040650653Support · corrodedAFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 727D+10 - 847. R & R SUPPORT IAW SRM.SDR SWAA2016040150512Support · corrodedFORWARD CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 460 - 500D, LBL 24. REPAIRED SUPPORT IAW SRM.SDR SWAA2016040650652Support · corrodedAFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT CORRODED, BETWEEN BS 727C+10 - 767. R & R SUPPORT IAW SRM.SDR SWAA2016040650651Skin · crackedLEFT WING NR 2 SLAT SKIN CRACKED ON LOWER SURFACE AT ACTUATOR ATTACH POINT. REPAIRED SKIN IAW SRM.SDR SWAA2016040150511Shield · corrodedFORWARD CARGO BAY RT SHIELD CORRODED, BETWEEN BS 420 - 440. R & R SHIELD IAW SRM.SDR SWAA2016021148979Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, STRINGER 23R. REPAIRED WEB IAW EA.SDR SWAA2016021048920Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED, AT BS 1016, BETWEEN STRINGER 15R - 23R. REPAIRED WEB IAW EA.SDR SWAA2016011247923Fitting · corrodedLEFT MLG TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016011247922Fitting · corrodedRIGHT MLG TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016011147886Fitting · corrodedLEFT MLG TRUNNION FITTING LUG FACES CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2016011147885Fitting · corrodedRIGHT MLG TRUNNION FITTING LUG FACES CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2015081342788Rib · crackedRIGHT HORIZONTAL STABILIZER STATION 92.70, RIB CRACKED 10" AFT FROM LE. REPAIRED STABILIZER IAW SRM.SDR SWAA2014111734202Support Bracket · crackedFUSELAGE RT RAM AIR DUCT FWD SUPPORT BRACKET CRACKED. R & R BRACKET IAW SRM & EA.SDR SWAA2014111734201Floor Support · crackedRIGHT OF CTR FLOORBOARD SUPPORT FRAME CRACKED BETWEEN BS 344 TO 360. R & R SUPPORT IAW SRM.SDR SWAA2014111734200Floor Support · crackedLEFT OF CTR FLOORBOARD SUPPORT FRAME CRACKED BETWEEN BS 344 TO 360. R & R SUPPORT IAW AMM.SDR SWAA2014111734199Attach Bracket · crackedFUSELAGE KEEL BEAM ACCESS PANEL 192E FWD RT ATTACH BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2014111734217Support Bracket · crackedRIGHT WW RAM AIR EXHAUST SUPPORT BRACKET CRACKED AT BS 663, RBL 15.54. R & R BRACKET IAW SRM.SDR SWAA2014111734216Support · crackedRIGHT MAIN WW VERTICAL SUPPORT FRAME CRACKED AT BS 663, RBL 25. R & R SUPPORT IAW SRM.SDR SWAA2014051227871Cover · looseR1 DOOR EMERGENCY EXIT FWD SIDEWALL LIGHT COVER LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014050727773Fitting · crackedLEFT WING UPPER CLIP AT REAR SPAR, INBD OF BOOST PUMP AT WBL 94.24 CRACKED. R & R CLIP IAW SRM & DWG.SDR SWAA2014050527687Light · crackedLEFT EEPLS CRACKED BETWEEN BS 340 TO BS 727B. R & R EEPLS IAW AMM.SDR SWAA2014050527676Light · crackedRIGHT EEPLS CRACKED BETWEEN BS 340 TO BS 727B. R & R EEPLS IAW AMM.SDR SWAA2014040326780Bracket · crackedLEFT WING NR 1 SLAT BRACKET CRACKED. R & R BRACKET IAW DWG.SDR SWAA2013091320128Frame · crackedFRAME CRACKED AT STATION 907 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013091320127Window Frame · crackedLT NR 1 WINDOW FRAME UPPER OTBD CORNER OF CD POST UPPER TWO FASTENER HOLES IN VERTICAL LEG OF FRAME CRACKED. R&R FRAME IAW ACO.SDR SWAA2013091220109Window Frame · crackedRT NR 1 COCKPIT WINDOW FRAME UPPER FASTENER HOLE CRACKED IN VERTICAL LEG. R&R FRAME IAW ACO.SDR SWAA2013091220108Window Frame · crackedLT NR 1 WINDOW FRAME UPPER OTBD CORNER OF CD POST CRACKED. R&R FRAME IAW ACO.SDR SWAA2013091020042Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090919989Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090619901Frame · crackedFRAME CRACKED AT STATION 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013083019725Frame · crackedFRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013083019724Frame · crackedFRAME CRACKED AT STATION 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013083019723Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8R. REPAIRED FRAME IAW EA.
Back to N705SW, cancelled Nov 7, 2024