N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 SWAA2012030501930Latch · looseFIRST OFFIER'S ESCAPE ROPE STOWAGE DOOR EXCESS STRAP DOOR LATCH ASSY LOOSE. REMOVED AND REPLACED LATCH ASSY PER MM.SDR SWAA2012022401716Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 727A, STR 26R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2012022401715Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 787, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2012022001597Stringer · crackedSTRINGER CRACKED AT BS 905, S27R. REPAIRED STRINGER PER SRM.SDR SWAA2012022101622Stringer · corrodedSTRINGER CORRODED AT BS 532, . REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA201201243Stringer · crackedSTRINGER CRACKED BS 530 STR 26R. REPAIRED STRINIGER IAW SRM.SDR SWAA2012022101621Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 787, STR 26R. REMOVED AND REPLACED STRINGER CLIP IAW SRM.SDR SWAA2012022101620Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727E, STR 26L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2012021301404Stringer Clip · crackedBS 747, STR 25R STRINGER CLIP CRACKED. REMOVED CLIP PER SRM AND DWG.SDR SWAA2012021301403Stringer Clip · crackedBS 727E, STR 26R STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA2012021301402Stringer Clip · crackedBS 747, STR 26R STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA2012021301401Stringer Clip · crackedBS 807, STR 26L STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA2012021301400Stringer Clip · crackedBS 747, STR 26L STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA2012020901288Stringer Clip · crackedBS 767, STR 25R STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012020901287Stringer Clip · crackedBS 727E, STR 25R STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012020901286Stringer Clip · crackedBS 727D, STR 26L STRINGER CLIP CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120767Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA120758Floor Support · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 767, RBL 8. REPAIRED SUPPORT IAW EA.SDR SWAA120755Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 24L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA120647Support Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME SUPPORT ANGLE CRACKED AT BS 500D, STR 21R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA120646Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKD AT BS 500B, STR 21L. REPAIRED CLIP IAW SRM.SDR SWAA2012022001596Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STR 26L TO 27L. REMOVED AND REPLACED SHEAR TIE IAW SRM, DWG AND MPM.SDR SWAA201201214Stiffener · crackedAFT CARGO BAY, VERTICAL STIFFENER CRACKED I/B SIDE OF RT KEEL BEAM AFT SIDE OF BS 727 BULKHEAD. REMOVED STIFFENERS IAW DWG AND SRM.SDR SWAA201201213Stiffener · crackedAFT CARGO BAY, VERTICAL STIFFENER CRACKED I/B SIDE OF LT KEEL BEAM AFT SIDE OF BS 727 BULKHEAD. REMOVED AND REPLACED STIFFENERS IAW SRM AND DWG.SDR SWAA2012021401450Skin · crackedSKIN CRACKED AT BS 473, STR 16R. REPAIRED SKIN PER ER AND EA.SDR SWAA120535Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 727E TO BS 747, LBL 70. REPAIRED WEB PER SRM.SDR SWAA120534Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 727D TO BS 727E, LBL 70. REPAIRED WEB PER SRM.SDR SWAA120533Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 727C TO BS 727D, LBL 70. REPAIRED WEB PER SRM.SDR SWAA201201212Intercostal · crackedBS 304 STR 16L INTERCOSTAL CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM AND DWG.SDR SWAA1201189Shear Tie · corrodedSHEAR TIE BS 520 BETWEEN STR 28L-27L IS CORRODED. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012021301399Crease Beam · corrodedCREASE BEAM CHORD CORRODED AT BS 390, WL 208 RT. REPAIRED CHORD PER ER AND EA.SDR SWAA1201188Shear Tie · crackedFRAME SHEAR TIE CRACKED AT STR 16L BS 400. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012022401697Skin · crackedR1 DOOR CUTOUT FWD LOWER CORNER SKIN IS CRACKED. REPAIRED SKIN PER ER AND EA.SDR SWAA201201211Shear Web · corrodedCORROSION ON CREASE BEAM SHEAR WEB BS 727B-727C, LBL 70. REMOVED WEB PER SRM.SDR SWAA201201210Shear Web · corrodedCORROSION ON CREASE BEAM SHEAR WEB, BLS 500A-500B, LBL 70. REMOVED WEB PER SRM.SDR SWAA201201209Shear Web · corrodedCORROSION ON CREASE BEAM SHEAR WEB, BLS 420-440, RBL 70. REMOVED WEB PER SRM.SDR SWAA201201208Shear Web · corrodedCORROSION ON CREASE BEAM SHEAR WEB, BS 380-400, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA1201187Shear Web · corrodedCORROSION ON CREASE BEAM SHEAR WEB, BS 480-500, LBL 70, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2012022101627Frame · crackedFWD CARGO COMPARTMENT FRAME WEB CRACKED AT BS 438, STR 24R. REMOVED AND REPLACED WEB INTERCOSTAL PER SRM.SDR SWAA2012021401449Floor Support · corrodedFLOOR SUPPORT CORRODED AT BS 767, LBL 2.5. REMOVED AND REPLACED SUPPORT PER SRM.SDR SWAA201201242Channel · corrodedCORROSION ON STRINGER TO BULKHEAD TIE CHANNEL AT BS 532 STR 26R. REMOVED & REPLACED CHANNEL IAW SRM.SDR SWAA1201186Stringer · corrodedCORROSION ON STRINGER STR 25L BS 967-987. REPAIRED STRINGER PER SRM.SDR SWAA1201185Keelbeam · corrodedCORROSION ON LEFT KEEL BEAM, BS 500D+15" TO BS 520, STR 28L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA2012022001595Skin · crackedSKIN CRACKED AT BS 500D+13, STR 16R. REPAIRED SKIN PER ER AND EA.SDR SWAA115983Lens · looseL1 DOOR EMERGENCY EXIT SIGN LOOSE. SECURED LENS PER MM.SDR SWAA114502Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 747+3 TO BS 747+14, STR 18L. REPAIRED SKIN PER EA.SDR SWAA114306Cable · misroutedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE MISROUTED. RE-ROUTED CABLE IAW MM.SDR SWAA114307Cable · misroutedDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE MISROUTED. REROUTED CABLE IAW MM.SDR SWAA112663Stringer Splice · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA112662Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 909, STR 4L. REPAIRED SKIN PER ER AND EA.
Back to N670SW, cancelled Jan 8, 2022