N384SW, cancelled Aug 3, 2018
Service difficulty reports · 368
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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 SWAA116340Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT BATTERY INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA115524Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WINDOW SKIN CRACKED AT BS 887+10, UPPER AFT CORNER. REPAIRED SKIN IAW TC.SDR SWAA115438Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 775 TO BS 782, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA115090Cable · misroutedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE MISROUTED. REROUTED CABLE IAW MM.SDR SWAA114370Sign · looseLT OVERWING DOOR EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA113508Stringer Clip · crackedDURING SCHEDULED RON CHECK FOUND, STR CLIP CRACKED AT BS 767 STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113507Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 763, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113506Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 767, STR 4R. REPAIRED PER EA.SDR SWAA113505Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 767-2, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113504Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 747+8, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113503Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 727B+16, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113502Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 727B+8, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113501Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 500D+10, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113500Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 727D +10, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113499Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 797, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113498Skin · crackedDURING SCHEDULED RON CHECK FOUND, SKIN CRACKED AT STA 830, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA113318Skin · crackedDURING SCHEDULED RON CHECK FOUND FUSELAGE SKIN CRACK, STA 900, STR 10L. REPAIRED PER DOC.SDR SWAA107849Uplock Sensor · faultyRT GEAR 'RED' LIGHT ON DURING APPROACH. RAISED GEAR AND LOWERED GEAR. ON SECOND APPROACH GOT 3 GREEN LIGHTS. REMOVED AND REPLACED RT MLG UPLOCK SENSOR PER MM.SDR SWAA107693Actuator · faultyRT MLG LIGHT ILLUMINATED INDICATING UNSAFE GEAR EXTENSION. (NO GREEN LIGHT) CYCLED GEAR HANDLE, SAME INDICATION. REMOVED AND REPLACED RT MLG GEAR DOWN LOCK ACTUATOR PER MM.SDR SWAA106860Skin · crackedDURING SCHEDULED RON CHECK, SKIN CRACKED AT BS 820, STR 4R. REPAIRED SKIN PER EA.SDR SWAA105585Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA103689Battery Pack · defectiveDURING SCHEDULED OTS CHECK, FOUND RT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT BROKEN BETWEEN ROW 1 TO ROW 4. REMOVED AND REPLACED BATTERY PACK.SDR SWAA103688Battery Pack · defectiveDURING SCHEDULED OTS CHECK, FOUND EMERGENCY EXIT LIGHT AT L1 DOOR BROKEN. REMOVED AND REPLACED BATTERY PACK.SDR SWAA103687Battery Pack · defectiveDURING SCHEDULED OTS CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHT AT R1 DOOR BROKEN. REMOVED AND REPLACED BATTERY PACK.SDR SWAA103048Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103047Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 328, RBL 13 TO RBL 45. REPAIRED FLOOR BEAM PER TYP REPAIR MANUAL.SDR SWAA103046Doubler · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN DOUBLER CRACKED AT BS 847 TO BS 867, STR 4R. REPAIRED SKIN PER EA.SDR SWAA103045Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 21R CRACKED AT BS 328. REPAIRED STRINGER PER SRM.SDR SWAA103044Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 20R CRACKED AT BS 328. REPAIRED STRINGER PER SRM.SDR SWAA103043Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA103042Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOOR CHANNEL CORRODED AT BS 927+17, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA103021Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND SKIN CORRODED AT BS 527, STR 28R. REPAIRED SKIN PER EO.SDR SWAA103020Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 733D, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA103019Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 734C, BETWEEN LBL 8 TO LBL 10. REPAIRED CHANNEL PER EA.SDR SWAA103018Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND RT WING NR 6 SLAT CRACKED AT O/B EDGE. REPAIRED NR 6 SLAT PER SRM.SDR SWAA103017Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO COMPT SHEAR TIE CORRODED AT BS 380, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER EO.SDR SWAA103016Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO COMPT BEAR STRAP SKIN CORRODED BETWEEN BS 500 TO BS 500A, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER EO.SDR SWAA103015Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO COMPT BEAR STRAP SKIN CORRODED BETWEEN BS 492 TO BS 500, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER EO.SDR SWAA103014Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 787 TO BS 807, STR 4L. REPAIRED SKIN PER AEM.SDR SWAA103013Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 727E TO BS 747, STR 4R. REPAIRED SKIN PER AEM.SDR SWAA103012Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 767 TO BS 787, STR 4R. REPAIRED SKIN PER AEM.SDR SWAA103011Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 907 TO BS 927, STR 10R. REPAIRED SKIN PER AEM.SDR SWAA103010Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT LOWER CORNER. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA103009Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING I/B MID FLAP T/E UPPER SKIN CRACKED. REPAIRED MID FLAP PER AEM.SDR SWAA103008Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 904, BETWEEN STR 26R TO STR 27R. REPAIRED CHANNEL PER EA.SDR SWAA103007Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 915, BETWEEN STR 27L TO STR 27R. REPAIRED CHANNEL PER EA.SDR SWAA103006Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 860, BETWEEN STR 26R TO STR 27R. REPAIRED CHANNEL PER EA.SDR SWAA103005Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 845.5, BETWEEN STR 27L TO STR 27R. REPAIRED CHANNEL PER EA.SDR SWAA103004Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 944, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA103003Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 813.5, RBL 8.10. REPAIRED CHANNEL PER EA.
Back to N384SW, cancelled Aug 3, 2018