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 SWAA2014043027536Skin · crackedFUSELAGE EXTERNAL SKIN FWD CARGO DOOR CUT OUT CRACKED AT BS 440+6, STRINGER 18R. REPAIRED SKIN IAW SRM.SDR SWAA2014042827390Channel · crackedCHANNEL CRACKED BETWEEN BS 663 TO BS 670, RBL 24.5+12. R & R CHANNEL IAW EO & EA.SDR SWAA2014042427349Angle · crackedANGLE CRACKED AT BS 727, BETWEEN LBL 45 TO LBL 52. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042427348Frame · corrodedFRAME CORRODED AT BS 360 & BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014042227272Cover · crackedRIGHT EE COMPARTMENT COVER ASSEMBLY CRACKED. R & R COVER ASSEMBLY IAW SRM & DWG.SDR SWAA2014041627171Strap · crackedSTRAP CRACKED AT BS 312, RBL 45. R & R STRAP IAW SRM & DWG.SDR SWAA2014041627170Strap · crackedSTRAP CRACKED AT BS 328, RBL 31. R & R STRAP IAW SRM & DWG.SDR SWAA2014042827389Frame · crackedFRAME CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW EA & DWG.SDR SWAA2014042827388Frame · crackedFRAME CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014042227271Angle · crackedLEFT EE COMPARTMENT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041427076Angle · crackedCLIP ANGLE CRACKED AT BS 320, BETWEEN STRINGER 20L TO STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040726852Fitting · crackedCLIP CRACKED AT BS 336, BETWEEN STRINGER 20L TO STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2014040726851Fitting · crackedCLIP CRACKED AT BS 328, BETWEEN STRINGER 20L TO STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2014050127582Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 348.2, STRINGER 16L. R & R CLIP IAW SRM & EA.SDR SWAA2014043027535Skin · crackedSKIN CRACKED AT BS 794+3, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014042827437Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014042827436Bulkhead · canningAFT PRESS BULKHEAD DOME WEB OIL CANNING AT BS 1016, RBL 60. REPAIRED DOME WEB IAW EO & EA.SDR SWAA2014042827387Stiffener · crackedZ STIFFENER CRACKED AT BS 1016, STRINGER 3L. REPAIRED Z STIFFENER IAW EO & EA.SDR SWAA2014042827403Structure · crackedLEFT WING UPPER CHORD CRACKED AT LEVEL S 2 & WBL 114 FUEL TANK. REPAIRED CHORD IAW EO & EA.SDR SWAA2014042427347Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042827392Web · crackedLEFT NLG WW WEB CRACKED AT BS 251.625+7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014042827384Web · crackedLEFT SIDE NLG WW WEB CRACKED AT BS 251.625+7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014042827378Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 807, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042427346Frame · crackedFRAME CRACKED AT BS 500B, STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014042327324Support Angle · crackedSUPPORT ZEE CRACKED BETWEEN BS 727C TO BS 727D, STRINGER 25R. R & R SUPPORT ZEE IAW SRM.SDR SWAA2014041627169Support · crackedSIDEWALL PANEL SUPPORT STRUCTURE CRACKED AT BS 747, STRINGER 19L. REPAIRED STRUCTURE IAW SRM.SDR SWAA2014041427075Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM.SDR SWAA2014041427074Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827381Skin · crackedSKIN CRACKED AT BS 328.1, STRINGER 17R. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014042227270Fitting · crackedCLIP CRACKED AT BS 947, BETWEEN STRINGER 24L TO STRINGER 25L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042227269Fitting · crackedCLIP CRACKED AT BS 947, BETWEEN STRINGER 24R TO STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2014043027533Structure · crackedT CHORD CRACKED AFT END OF THE CROSSBEAM OF AFT CARGO DOOR. REPAIRED T CHORD IAW EA.SDR SWAA2014042827380Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 663.75+1.5, RBL 24.5+14. REPAIRED WEB IAW EO & EA.SDR SWAA2014041727197Girt Bar · out of positionL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED GIRT BAR IAW MT.SDR SWAA2014043027532Structure · crackedCHORD CRACKED AT BS 727, 18A LT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA 12 & 6 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2014043027531Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA 3 & 9 O'CLOCK DIRECTION. REPAIRED CHORD IAW EA.SDR SWAA2014041627168Web · crackedWEB CRACKED AT BS 227.8, BL 0. R & R WEB IAW SRM & DWG.SDR SWAA2014041026982Support Angle · crackedLEFT MAIN WW SUPPORT ANGLE CRACKED AT BS 727, LBL 16. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040726850Plate · crackedPLATE CRACKED AT BS 697, STRINGER 21L. R & R PLATE IAW SRM.SDR SWAA2014040726849Plate · crackedPLATE CRACKED AT BS 697, STRINGER 21R. R & R PLATE IAW SRM.SDR SWAA2014060328630Slide · unsecureR1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014031726105Sign · damagedCTR AISLE EMERGENCY EXIT SIGN DAMAGED AT ROW 2. R & R SIGN IAW AMM.SDR SWAA2014022425440Structure · crackedR1 DOOR UPPER HINGE ARM CUT OUT AFT CORNER CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014012024267Sign · brokenFWD ENTRY DOOR EMERGENCY EXIT SIGN BROKEN. R & R SIGN IAW AMM.SDR SWAA2013121323262Slide · unsecureL1 DOOR ESCAPE SLIDE CAME OUT OF HOLDING CASE BUT DID NOT DEPLOY. REINSERTED L1 DOOR SLIDE IN CASE IAW MT.SDR SWAA2013080818945Bracket · crackedLT WING CRACKED BRACKET AT INBD AFT EDGE OF PYLON PANEL 5735L. R&R BRACKET IAW SRM.SDR SWAA2013080818944Flap · delaminatedLT WING INBD FLAP DELAMINATED. R&R AFT FLAP IAW AMM.SDR SWAA2013080818943Tab · delaminatedLT WING AILERON TAB DELAMINATED. R&R TAB IAW AMM.SDR SWAA2013062417460Flap · delaminatedLT WING OUTBOARD TRAILING EDGE FLAP DELAMINATED INBOARD OF INBOARD FLAP TRACK. R&R AFT FLAP IAW MM.SDR SWAA2013040414475Support Angle · crackedLEFT WING LOWER TRAILING EDGE PANEL SUPPORT ANGLE JUST O/B OF NR 3 FLAP TRACK FAIRING CRACKED. REPAIRED ANGLE IAW EA & SRM.
Back to N384SW, cancelled Aug 3, 2018