N348SW, cancelled Jul 16, 2012
Service difficulty reports · 282
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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 SWAA2012050203642Outflow Valve · malfunctionedCABIN WARNING HORN SOUNDED AT 36K. CABIN AT 11.5K AT HIGHEST POINT. AT 25K DURING EMERGENCY DESCENT REGAINED CONTROL OF CABIN AT 25K, LEVELED OFF AT 20K. REMOVED AND REPLACED OUT FLOW VALVE AND HEATER GASKET PER MM.SDR SWAA2012040502834Light · inoperativeL1 DOOR OPENING HAS EMERGENCY LIGHT STRIP BULB INOP. RELAMPED PER MM.SDR SWAA2012022701760Duct · looseEMERGENCY DESCENT, LOSS OF PRESSURIZATION AT FL350 CABIN ALT REACHED 15,000FT DURING DESCENT TO 10,000FT LOSS OF PRESS & EMERG DESCENT QRH COMPLETE "PASS OXYGEN ON" LIGHT WITH DROPPED MASK DURING DESCENT. REMOVED AND REPLACED BOOT, DUCT, AND CLAMP PER MM.SDR SWAA117925Fan · faultyAT CRUISE, FLIGHT ATTENDANTS REPORTED FAINT "BURNING RUBBER" ODOR FROM VENTILATION. REMOVED AND REPLACED RECIRULATION FAN PER MM.SDR SWAA116466Battery · dischargedDURING SCHEDULED SPV CHECK, FOUND FORWARD EMERGENCY EXIT SIGNS INOP. CHARGED BATTERIES PER MM.SDR SWAA116465Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 740, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA116464Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 727E+12.5 TO BS 727E+13, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA116463Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 500B+16, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA116462Beam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL BEAM WEB CRACKED AT BS 639, RBL 45.5. REPAIRED WEB PER ER.SDR SWAA116337Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 759 TO BS 761.5, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA116336Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED AT BS 500+5, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA116335Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED AT BS 494.5, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA113086Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT. RE-INSTALLED SLIDE PER MT.SDR SWAA110733Gasper Fan · faultyAIR TURNBACK, UPON LEVEL OFF AT FL 310 FLIGHT ATTENDANT REPORTED THERE WAS A STRONG ELECTRICAL SMOKE SMELL IN AFT CABIN. VERIFIED GASPER FAN EMITTING ODOR. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA111837Skin · crackedDURING SCHEDULED SPV CHECK, FOUND CRACK AT STA 727E +3, BELOW STR 19R. REPAIRED DOUBLER PER SRM.SDR SWAA110428Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 911, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA110427Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 730E, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA110426Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 730E, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA106658Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 821, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA106307Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 328, STR 17R. REPAIRED SKIN PER EO AND EA.SDR SWAA106306Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 960, STR 17L. REPAIRED SKIN PER EO AND EA.SDR SWAA106305Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668.75, LBL 24.8. REPAIRED CHORD PER EO.SDR SWAA106292Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND SKIN CORRODED AT BS 1002.5, STR 23L. REMOVED AND REPLACED SKIN PER SRM AND BAC DWG.SDR SWAA106291Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN STRAP CRACKED AT BS 950.5, STR 24L. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA106178Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B FORE FLAP UPPER SKIN I/B DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA106176Light · brokenDURING SCHEDULED 22Y CHECK, FOUND RT EEPLS BROKEN. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA106175Light · brokenDURING SCHEDULED 22Y CHECK, FOUND LT EEPLS BROKEN. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA106173Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA106172Light · damagedDURING SCHEDULED 22Y CHECK, FOUND EEPLS DAMAGED. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA106171Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND FWD OVERHEAD EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA106170Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA106169Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA106168Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 1112, STR 6R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA106109Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B FORE FLAP SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA106088Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 960, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA106086Support Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT ANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STR 11R TO STR 12R. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA106085Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA106023Support Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND ANGLE SUPPORT CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STR 9R TO STR 10R. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA106022Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105983Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 3 SLAT SKIN I/B END DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA105982Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 6 SLAT SKIN O/B DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA105861Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING AFT FLAP UPPER SKIN DELAMINATED AT O/B END. REPAIRED AFT FLAP PER SRM.SDR SWAA105860Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 1 SPOILER SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105859Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105858Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105826Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 1 SLAT SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105825Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 2 SLAT SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105824Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 4 SLAT SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105823Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105822Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 277, BETWEEN STR 14R TO STR 15R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.
Back to N348SW, cancelled Jul 16, 2012