N317WN, cancelled Mar 13, 2018
Service difficulty reports · 283
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 = 'N317WN' AND deregistration_id = 'N317WN-2018-03-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 = 'N317WN' AND deregistration_id = 'N317WN-2018-03-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 SWAA2013091820201Angle · corrodedUNDER GALLEY AFT CARGO COMPARTMENT ANGLE CORRODED AT BS 1022, BL 0. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091120057Tie Clip · crackedTIE CLIP CRACKED AT STATION 294.5, STRINGER 12L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013090919953Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 8L. R&R WEB IAW SRM & DRAWING.SDR SWAA2013093020560Panel · crackedCURVED CORRUGATED PANEL CRACKED LOCATED BETWEEN BS 720 TO BS 727 RBL 6.10 KEEL BEAM. R & R PANEL IAW SRM & DRAWING.SDR SWAA2013090619893Skin Panel · crackedLT WING FIXED LE LOWER SKIN PANEL CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2013100720858Structure · crackedCHORD CRACKED AT BS 665, BL 0.07. REPAIRED CHORD IAW EO & EA.SDR SWAA2013100720857Skin · crackedSKIN CRACKED AT BS 328+13, STRINGER 17L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013090519867Strap · crackedAFT CARGO COMPARTMENT STRAP CRACKED BETWEEN BS 727 TO BS 767, STRINGER 25R. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013100720856Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED AT BS 661 BBL 0.07. REPAIRED CHORD IAW EO & EA.SDR SWAA2013100720855Structure · crackedCHORD CRACKED AT BS 727 UPPER AFT LOWER FWD & LOWER AFT FASTENER HOLES LT SIDE 3 O'CLOC. REPAIRED CHORD IAW EO &EA.SDR SWAA2013100720854Structure · crackedCHORD AT AFT LOWER FASTENER HOLE CRACKED AT BS 727 INSPECTION AREA RT SIDE 5 O'CLOCK POSITION. REPAIRED CHORD IAW EA.SDR SWAA2013100720853Stringer · crackedSTRINGER CRACKED AT BS 727 STRINGER 18A AT AFT LOWER FASTENER HOLE RT SIDE. REPAIRED STRINGER IAW EA.SDR SWAA2013100720852Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 665, RBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2013100720843Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED AT BS 661 BBL 0.07. REPAIRED WEB IAW EO & EA.SDR SWAA2013090919952Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED BETWEEN BS 705 TO BS 715, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013071118093Gasper Fan · faultyBURNING RUBBER SMELL FORWARD GALLEY AREA & FIRST 5 ROWS, GASPER WAS ON, TURNED OFF. SMELL SUBSIDED. R&R GASPER FAN & RECIRC FAN FILTER IAW MM.SDR SWAA2012091107504Light · inoperativeLEFT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 10. REMOVED & REPLACED BULB PER AMM.SDR SWAA2012091007491Light · inoperativeLEFT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 10. REMOVED & REPLACED BULB PER AMM.SDR SWAA2012082306910Skin · delaminatedRIGHT WING NR 5 SLAT DELAMINATED ON UPPER INBOARD SKIN EDGE. REMOVED AND REPLACED SKIN IAW AMM.SDR SWAA2012080106383Lens · looseR1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012070605561Light · inoperativeLEFT MLG NO GREEN LIGHT AND NO RED LIGHT WITH GEAR SELECTED DOWN. GEAR SELECTED UP, SYSTEM TEST GREEN LIGHT WILL NOT ILLUMINATE. RELAMP AND TEST GOOD PER MM.SDR SWAA2012051604041Pin · inoperativeEMERGENCY LIGHTS FOUND GROUND WIRE PIN INOP. REMOVED AND REPLACED PIN PER WDM.SDR SWAA2012051604039Battery Pack · failedRIGHT FWD EMERGENCY LIGHT BATTERY PACK HOUSING FAILED. REPLACED BATTERY PACK HOUSING PER M/M.SDR SWAA2012030902017Housing · defectiveR1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY HOUSING PER MM.SDR SWAA2012020201545Window · arcedR1 WINDOW ARCED DURNG DESCENT THEN IT CRACKED. REMOVED AND REPLACED R1 WINDOW PER MM.SDR SWAA2012020901261Battery Pack · dischargedFWD GALLEY EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER M/M.SDR SWAA120472Battery Pack · dischargedRT FWD EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA120178Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME INNER CHORD WEB CRACKED AT BS 360, STR 20R. REPAIRED WEB IAW SRM.SDR SWAA120093Pressure Deck · crackedDURING SCHEDULED 24Y CHECK, FOUND PRESSURE DECK UPPER WEB CRACKED AT BS 664, LBL 31.0. REPAIRED WEB IAW EA.SDR SWAA120002Stringer Splice · crackedDURING SCHEDULED 24Y CHECK FOUND, STRINGER SPLICE CRACKED AT BS 359, STR 7L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA118608Lens · crazedDURING SCHEDULED 24Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS CRAZED. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA118566Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT KEEL BEAM ANGLE CORRODED AT BS 540, RBL 12. REPAIRED ANGLE IAW SRM AND DWG.SDR SWAA118565Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 540, STR 27R. REPAIRED FRAME PER EA.SDR SWAA118564Pressure Panel · crackedDURING SCHEDULED 24Y CHECK, FOUND BEADED HORIZONTAL PRESSURE WEB CRACKED AT BS 664, LBL 39.5. REPAIRED WEB PER EA.SDR SWAA118494Web · crackedDURING SCHEDULED 24Y CHECK, FOUND FLIGHT DECK FLOOR WEB OPC COMPUTER CRADLE BRACKED, FWD O/B MOUNT HOLE CRACKED AT BS 246.6, RBL 22. REPAIRED WEB IAW EA.SDR SWAA118495Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT KEEL BEAM CORRODED AT STA 540. REMOVED AND REPLACED KEEL BEAM SECTION PER SRM.SDR SWAA118493Lens · dirtyDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS DISCOLORED. CLEANED LENS PER MM.SDR SWAA118492Web · crackedDURING SCHEDULED 24Y CHECK, FOUND FLIGHT DECK FLOOR WEB CRACKED AT BS 246.6, RBL 15. REPAIRED WEB IAW EA.SDR SWAA118382Cusp Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND CUSP WEB CORRODED AT BS 597, STR 17L. REPAIRED WEB IAW SRM.SDR SWAA118359Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND RT FRAME I/B LOWER FASTENER INNER CHORD CRACKED AT BS 616. REPAIRED CHORD PER SWA EA.SDR SWAA118288ASlide · low pressureDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. R&R SLIDE PER MM.SDR SWAA118285AStringer Clip · damagedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP DAMAGED AT BS 907, STR 19L. R&R CLIP IAW SRM.SDR SWAA118475Cusp Web · crackedDURING SCHEDULED 24Y CHECK, FOUND CUSP WEB CRACKED AT BS 639, STR 17L. REPAIRED WEB PER EA.SDR SWAA20111211474Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016 AT APPROX 5 O'CLOCK POSITION AT CENTER OF DOME CAP CENTER. REPAIRED BULKHEAD PER SRM.SDR SWAA118473Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016 AT APPROX 2 O'CLOCK POSITION AT CENTER OF DOME CAP CENTER. REPAIRED BULKHEAD PER SRM.SDR SWAA20111211472Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016 AT APPROX 7 O'CLOCK POSITION AT CENTER OF DOME CAP CENTER. REPAIRED BULKHEAD PER SRM.SDR SWAA20111211471Bulkhead · damagedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD CREASED AT BS 1016, ON AFT SIDE AT STIFFENER 10 AND 8 INCHES DOWN FROM CENTER OF PRESSURE WEB. REPAIRED BULKHEAD PER SRM.SDR SWAA20111211470Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 480 TO BS 500, STR 17L. REPAIRED BEAM IAW EA.SDR SWAA117508Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA115837Outflow Valve · faultyCABIN ALT WARNING HORN AT FL 340, CABIN ALTITUDE 10,500. REMOVED AND REPLACED MAIN OUTFLOW VALVE PER MM.
Back to N317WN, cancelled Mar 13, 2018