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 SWAA020160Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM CORRODED AT BS 520. REPAIRED KEEL BEAM PER SRM.SDR SWAA013114Charger · inoperativeDURING SCHEDULED BC2 CHECK, FOUND EEPLS INOP AT MID CABIN. REMOVED AND REPLACED BATTERY CHARGER AND REPAIRED WIRES PER MM.SDR SWAA012948Wire · damagedDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP BETWEEN ROWS 11-17. REPAIRED EEPLS WIRING PER MM.SDR SWAA012613Light · looseEEPLS LOOSE AT SEVERAL LOCATIONS IN CABIN. SECURED EEPLS PER MM.SDR SWAA012214Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKS AT WL 199, LBL 5 & WL 202, RBL 5. REPAIRED FWD BULKHEAD WEB PER SRM.SDR SWAA012180Light · looseEEPLS LOOSE. SECURED EEPLS PER MM.SDR SWAA012071Support Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LH & RH MLG WALKING BEAM SUPPORT FITTINGS CORRODED. R&R MLG SUPPORT FITTINGS PER MM.SDR SWAA011554Wire · damagedDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT CENTER CABIN. REPAIRED AND SECURED LOOSE WIRING PER MM.SDR SWAA010492Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR OPENING. LATER AT BHM, CONTAINER CAME LOOSE FROM DOOR. REINSTALLED SLIDE ASSY AND SECURED CONTAINER TO DOOR PER MM.SDR SWAA002074Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING INBOARD T/E FLAP DELAMINTED AT OUTBOARD LOWER END. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA001642Wheel · vibrationAIR TURNBACK, SEVERE VIBRATION FELT FROM NLG TIRES DURING TAKEOFF. REMOVED AND REPLACED BOTH NLG TIRE/WHEEL ASSY''S AND LUBED NLG TORQUE LINKS PER MM.SDR SWAA001393Light · looseEEPLS TRACK LOOSE AT ROW 16. SECURED TRACK PER MM.SDR SWAA000132Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND SEVERAL EEPLS INOP. REMOVED AND REPLACED LIGHT ASSY'S PER MM.SDR SWAA991864Girt · out of positionDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY PER MM.SDR SWAA991189Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND LOWER STUB FRAME CRACKED, BS 294, RBL54. REPAIRED FRAME PER SRM.SDR SWAA991026Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND EMERGENCY ESCAPE FLOOR TRACK LIGHT INOP BETWEEN ROWS 11-12. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA990455Bearing · leakingAIR TURNBACK DUE TO CABIN FILLED WITH SMOKE AFTER TAKEOFF. FOUND NR 3 BEARING LEAKING OIL ON NR 2 ENGINE. REMOVED AND REPLACED ENGINE PER MM.SDR SWAA990349Floor · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FLOOR WEB AT BS 1016 LBL 38 TO 41.5 WL 208.5. REMOVED CORROSION ON FLOOR WEB BS 1016 LBL 38 - 41, WL 208.5 FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALLED NEW WEB PER SRM.
Back to N384SW, cancelled Aug 3, 2018