N522SW, cancelled Jan 6, 2020
Service difficulty reports · 351
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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 SWAA2015081942952Tie Clip · crackedTIE CLIP CRACKED AT BS 482, STRINGER 7L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015100544561Skin · crackedSKIN CRACKED BETWEEN BS 259.5+6 - 283, BETWEEN STRINGER 2L - 5L. REPAIRED SKIN IAW SRM.SDR SWAA2015100544560Skin · crackedSKIN CRACKED BETWEEN BS 348 - 380, BETWEEN STRINGER 2L - 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015100544559Skin · crackedSKIN CRACKED BETWEEN BS 482B - 540, BETWEEN STRINGER 14L - 18L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015100544558Skin · crackedSKIN CRACKED BETWEEN BS 482+8 - 482+19, BETWEEN STRINGER 25L - 27L. REPAIRED SKIN IAW SRM.SDR SWAA2015100544557Skin · crackedRIGHT WING REAR SPAR UPPER CHORD, AFT SKIN CRACKED AT RSS 222.5. REPAIRED SKIN IAW EO & EA.SDR SWAA2015100544556Skin · crackedSKIN CRACKED BETWEEN BS 867 - 88, BETWEEN STRINGER 20R - 22R. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015100544555Skin · crackedSKIN CRACKED BETWEEN BS 400 - 460, BETWEEN STRINGER 1L - 3R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015100544554Skin · crackedSKIN CRACKED BETWEEN BS 807+7 - 827+13, BETWEEN STRINGER 23L - 26L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015100144456Skin · crackedSKIN CRACKED AT BS 867+5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2015100144455Skin · crackedSKIN CRACKED AT BS 847+15.5, STRINGER 15R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015100144454Skin · crackedSKIN CRACKED AT BS 787+16.5, STRINGER 24L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015092844320Skin · crackedSKIN CRACKED AT BS 767+16, STRINGER 22L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015091844037Door Frame · crackedR2 DOOR AFT EDGE INTERNAL AREA FRAME CRACKED. R & R DOOR IAW AMM.SDR SWAA2015082843284Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, BETWEEN STRINGER 27R TO 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015100544553Skin · crackedSKIN CRACKED BETWEEN BS 908 - 1016, BETWEEN STRINGER 20R - 25R. R & R SKIN IAW EO & EA.SDR SWAA2015081742871Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2015081142739Door Frame · crackedENTRY DOOR FWD LOWER HINGE FRAME AT AFT GALLEY AREA CRACKED. REPAIRED FRAME IAW SRM.SDR SWAA2015070841483Lens · brokenFORWARD ENTRY WAY EXIT LIGHT COVER LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015050739416Battery · dischargedAFT GALLEY EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2015042438876Battery · dischargedAFT EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015020236263Attach Fitting · damagedRIGHT WING NR 6 SLAT INBD AUXILIARY TRACK ATTACH FITTING, DAMAGED AT AFT UPPER SPAR CAP. REPAIRED FITTING IAW EA & DWG.SDR SWAA2015020236278Slat · crackedRIGHT WING NR 5 SLAT COMPOSITE LE FIXED CRACKED ABOVE OTBD AUX TRACK. REPAIRED NR 5 SLAT IAW EA.SDR SWAA2015013036224Panel · crackedFORWARD ENTRY DOOR CUT OUT FWD LOWER CLOSEOUT PANEL CRACKED. REPAIRED PANEL IAW SRM.SDR SWAA2015013036223Bracket · crackedRIGHT WING AILERON COVER BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015012636043Lens · looseR2 DOOR EMER EXIT SIGN LENS LOOSE. R & R LENS IAW SIP.SDR SWAA2014122335249Skin · crackedFUSELAGE SKIN CRACKED AT STATION 799, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR SWAA2014121935165Skin · crackedFUSELAGE SKIN CRACKED AT STATION 798 TO 800, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR SWAA2014122235180Attach Fitting · crackedATTACH CLIP CRACKED AT RT FUSELAGE STATION 616, WL 208. R & R CLIP IAW EA.SDR SWAA2014122335248Skin · crackedFUSELAGE SKIN CRACKED AT STATION 807+15, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2014122335247Skin · crackedFUSELAGE SKIN CRACKED AT STATION 847+12, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014122335246Skin · crackedFUSELAGE SKIN CRACKED AT STATION 850, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014122335245Skin · crackedFUSELAGE SKIN CRACKED AT STATION 931, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2014122335244Skin · crackedFUSELAGE SKIN CRACKED AT STATION 444, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014121935159Skin · crackedFUSELAGE SKIN CRACKED AT STATION 787+6, STRINGER 25L. REPAIRED SKIN IAW EA.SDR SWAA2014120134567Spoiler · unknownRIGHT WING NR 6 FLIGHT SPOILER LEAKED. R & R SPOILER IAW MM.SDR SWAA2014111734223Flap · delaminatedLEFT OTBD AFT FLAP DELAMINATED ON INBD TE. R & R AFT FLAP IAW AMM.SDR SWAA2014102033141Light · inoperativeRIGHT OVERWING EXIT LOWER EMER EXIT LIGHT INOPERATIVE. REPAIRED LIGHT IAW SWPM.SDR SWAA2014100832764Lens · brokenR1 DOOR EXIT LIGHT LENS COVER BROKEN. SECURED LENS IAW EA.SDR SWAA2014091632046Bracket · dirtyR1 DOOR EMER EVAC SLIDE GIRT BAR RETAINING BRACKET DIRTY. CLEANED BRACKET IAW AMM.SDR SWAA2014061629085Light · inoperativeRIGHT LOWER OVERWING EMER EXIT LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014052128222Mount Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2014041427093Skin · crackedL1 DOOR SKIN CUT OUT LOWER AFT CORNER UNDER THRESHOLD PLATE CRACKED AT BS 348. REPAIRED SKIN IAW EA & SWA EA.SDR SWAA2014012024306Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 425 TO BS 428 STRINGER 26L. REPAIRED SKIN IAW SRM.SDR SWAA2013121623367Lens · unsecureEMERGENCY EXIT SIGN FELL OFF. R & R LENS IAW AMM.SDR SWAA2013090519881Tab · delaminatedRT WING AILERON TAB DELAMINATED OTBD END. R&R TAB IAW MM.SDR SWAA2013090519873Slat · delaminatedRT WING NR 5 SLAT WEDGE DELAMINATED ON OTB END. R&R NR 5 SLAT PER AMM.SDR SWAA2013080918986Fitting · corrodedL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR FITTING BOTH ADAPTER PLATES CORRODED. R&R FITTINGS IAW AMM.SDR SWAA2013080919005Fitting · corrodedR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR FITTING BOTH ADAPTER PLATES CORRODED. R&R FITTINGS IAW AMM.SDR SWAA2013080919006Stringer Clip · crackedAFT CARGO COMPARTMENT STRINGER CLIP CRACKED AT STATION 927, STRINGER 24L. R&R CLIP IAW DRAWING.
Back to N522SW, cancelled Jan 6, 2020