N526SW, cancelled Mar 27, 2018
Service difficulty reports · 422
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 = 'N526SW' AND deregistration_id = 'N526SW-2018-03-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 = 'N526SW' AND deregistration_id = 'N526SW-2018-03-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 SWAA2015072942279Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 663.75, STRINGER 10R. R & R THE STRINGER CLIP IAW DWG & SRM.SDR SWAA2015081142667Tie Clip · crackedTIE CLIP CRACKED AT BS 827, STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015091043622Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 18R - 19R. R & R FRAME IAW EA.SDR SWAA2015091043621Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 26R - 25R. REPAIRED FRAME IAW EO & EA.SDR SWAA2015091043620Frame · crackedFRAME CRACKED AT BS 380, STRINGER 16R. REPAIRED FRAME IAW EA & EO.SDR SWAA2015091043619Skin · crackedR1 DOOR SKIN WEB CRACKED ON FWD EDGE INTERNAL STRUCTURE. REPAIRED SKIN IAW EO & EA.SDR SWAA2015082843297Web · crackedWEB CRACKED AT BS 639, STRINGER 15L. R & R WEB IAW SRM & DWG.SDR SWAA2015081142740Tab · crackedRIGHT WING AILERON TAB CRACKED AT CORNER INBD SIDE. REPAIRED TAB IAW SRM.SDR SWAA2015080342441Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015091043618Shear Tie · crackedFRAME SHEAR TIE CRACKED AT BS 277, BETWEEN STRINGER 14R - 15R. REPAIRED SHEAR TIE IAW EA.SDR SWAA2015091043617Frame · crackedFRAME WEB CRACKED AT BS 291.5, BETWEEN STRINGER 9R - 10R. REPAIRED FRAME WEB IAW EO & EA.SDR SWAA2015091043616Web · corrodedAFT CARGO COMPARTMENT WEB CORRODED, BETWEEN BS 747 - 767, BETWEEN STRINGER 27L - 27R. REPAIRED WEB IAW EA.SDR SWAA2015091043608Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 26R - 25R. REPAIRED FRAME IAW EA.SDR SWAA2015091043607Support Angle · crackedAFT CARGO COMPARTMENT, SUPPORT ANGLE CRACKED AT BS 747, BETWEEN STRINGER 27R - 27L. REPAIRED ANGLE IAW EA.SDR SWAA2015091043606Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 19R - 18R. REPAIRED FRAME IAW EA.SDR SWAA2015083143348Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015082643229Stiffener · crackedAFT CARGO COMPARTMENT STIFFENER, CRACKED AT BS 727, LBL 45.5. R & R STIFFENER IAW SRM & DWG.SDR SWAA2015080342440Web · crackedAFT CARGO COMPARTMENT WEB CRACKED BETWEEN BS 787 TO 807, RBL 16. R & R WEB IAW SRM & DWG.SDR SWAA2015073042329Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015091043605Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2015091043604Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 26R. R & R TIE CLIP IAW EA.SDR SWAA2015083143358Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+5.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015082443097Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STRINGER 25R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015081442843Angle · crackedFORWARD ENTRY DOOR INTERNAL ANGLE CRACKED ON LOWER FWD CORNER CUT OUT. R & R ANGLE IAW SRM.SDR SWAA2015073042328Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 22R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015072942278Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R INTERCOSTAL IAW SRM.SDR SWAA2015072842265Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BL 0 TO RBL 24.5. R & R THE INTERCOSTAL IAW SRM.SDR SWAA2015072142087Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED BETWEEN BS 380 TO 400, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2015091443835Skin · crackedSKIN CRACKED AT BS 907+4.650, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2015091043614Skin · crackedSKIN CRACKED AT BS 908, STRINGER 3L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015091043613Skin · crackedSKIN CRACKED AT BS 360, STRINGER 7R. REPAIRED SKIN IAW SRM.SDR SWAA2015091043612Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STRINGER 6R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015090343478Skin · crackedSKIN CRACKED AT BS 360, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2015090343477Skin · crackedSKIN CRACKED AT BS 360, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015090143411Skin · crackedSKIN CRACKED AT BS 827+15, ABOVE STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015090143410Skin · crackedSKIN CRACKED AT BS 928+15, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2015091443834Skin · crackedSKIN CRACKED AT BS 927+14, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2015091443833Skin · crackedSKIN CRACKED AT BS 927+4, STRINGER 21L. R & R SKIN IAW EA.SDR SWAA2015091043610Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75, LBL 32. REPAIRED WEB IAW EA.SDR SWAA2015091043609Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75, LBL 38. REPAIRED WEB IAW EA.SDR SWAA2015022536899Cable · misroutedR2 DOOR EMER EVAC SLIDE CABLE MISROUTED. REROUTED CABLE IAW AMM.SDR SWAA2014112634478Frame · crackedSTUB FRAME CRACKED AT STATION 616, RBL 63 & WL 201.5. R & R STUB FRAME IAW SRM.SDR SWAA2014111834267Shear Web · crackedSHEAR WEB CRACKED AT BS 452, STRINGER 26R. R & R SHEAR WEB IAW DWG.SDR SWAA2014111834266Door Frame · crackedFORWARD CARGO DOOR CUT OUT AFT FRAME CRACKED AT BS 452 BETWEEN STRINGER 16R TO 26R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2014111834265Skin · crackedFUSELAGE SKIN CRACKED AT BS 482+5, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014111734227Skin · crackedFUSELAGE SKIN CRACKED AT BS 440+5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014111734226Light · inoperativeLEFT OVERWING EMER ESCAPE SLIDE LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014111734225Light · inoperativeRIGHT OVERWING DOOR EMER ESCAPE SLIDE LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014100632670Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2014100632669Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.
Back to N526SW, cancelled Mar 27, 2018