N325SW, cancelled Mar 28, 2012
Service difficulty reports · 344
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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 SWAA096827Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 358, BETWEEN STR 4R TO STR 5R. REPAIRED SKIN PER ER.SDR SWAA096826Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA096736Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 525, AT STR 5R. REPAIRED SKIN PER ER.SDR SWAA096735Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 362, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN PER ER.SDR SWAA096734Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 362, BETWEEN STR 8R TO STR 9R. REPAIRED SKIN PER ER.SDR SWAA096706Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096620Light · looseDURING SCHEDULED CV CHECK, FOUND LT EEPLS LOOSE AT ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA095699Flashlight · inoperativeDURING SCHEDULED MV2 CHECK, FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA095663Holder · defectiveFWD GALLEY EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED HOLDER ASSY PER MM.SDR SWAA093921Spar · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING FWD SPAR LOWER CHORD CRACKED AT NR 2 PYLON RT SKATE ANGLE, FWD FASTENER HOLE. REPAIRED SPAR PER SWA EA.SDR SWAA093889Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 767, STR 13L. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA093684Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, BS 288, WL 253. REPAIRED SKIN PER SWA EA.SDR SWAA093683Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, BS 295, WL 271. REPAIRED SKIN PER SWA EA.SDR SWAA093682Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, BS 292, WL 261. REPAIRED SKIN PER SWA EA.SDR SWAA093475Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 590, STR 15R. REPAIRED STRINGER PER SRM.SDR SWAA093476Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 827, STR 13L. REPAIRED SKIN PER SWA EA.SDR SWAA093285Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294.5, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA093215Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 291.75, WL 258. REPAIRED SKIN PER SWA EA.SDR SWAA093016Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND BS 559 RT LWR FWD AND AFT FASTENER HOLES COMMON TO THE WING CHORD CRACKED. REPAIRED FRAME PER SWA EA.SDR SWAA092982Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BETWEEN BS 290 TO BS 291, BETWEEN WL 232 TO WL 234. REPAIRED SKIN PER SWA EA.SDR SWAA092920Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 13L. REPAIRED FRAME PER EA.SDR SWAA092919Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER CUTOUT, BS 301. REPAIRED SKIN PER EA.SDR SWAA092860Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, WL 232. REPAIRED SKIN PER SWA EA.SDR SWAA092859Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 373.5, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA092858Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 397, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA092857Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 380, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA092830Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 500C, STR 13L. REPAIRED SKIN PER SWA EA.SDR SWAA092829Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 495, STR 23R. REPAIRED STRINGER PER SRM.SDR SWAA092828Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 932, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA092827Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA092811Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND NLG WHEEL WELL T-CHORD SKIN CRACKED AT BS 227.8, LBL 1. REPAIRED SKIN PER SWA EA.SDR SWAA092809Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 698 TO BS 717, BBL 0.07. REPAIRED BEAM PER SI.SDR SWAA092739Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 502D TO BS 518D, BETWEEN STR 12L TO STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA092738Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, BL 0, WL 204. REPAIRED BEAM PER SI.SDR SWAA092695Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092694Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA092693Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 712, BL 0.07, WL 204. REPAIRED BEAM PER SI.SDR SWAA092689Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092688Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092687Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092686Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA092684Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45.5, WL 208. REPAIRED BEAM PER SWA EA.SDR SWAA092683Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, LBL 24.5, WL 204. REPAIRED BEAM PER SWA EA.SDR SWAA092682Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 13R TO STR 14R WL 234. REPAIRED FRAME PER SWA EA.SDR SWAA092681Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 13R TO STR 14R WL 233. REPAIRED FRAME PER SWA EA.SDR SWAA092641Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND CENTER CABIN LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED FLOOR BEAM PER SWA EA.SDR SWAA092640Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND CENTER CABIN LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA092639Flap · debondedDURING SCHEDULED 22Y CHECK, FOUND RT WING OUTBOARD AFT FLAP DISBONDED NEAR INBOARD END. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA092585Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092584Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.
Back to N325SW, cancelled Mar 28, 2012