N264LV
Service difficulty reports · 274
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 = 'N264LV' AND registry_match = 'registration' 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 = 'N264LV' AND registry_match = 'registration' 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 SWAA2018103026350Light · damagedOVERWING EMERGENCY EXIT LIGHT ATTACHED TO THE CENTERLINE DIFFUSER DAMAGED. INSTALLED LIGHT IAW AMM.SDR SWAA2022022420965Retainer · crackedR/W T/E VERTICAL SEAL RETAINER AT AFT PYLON TIP IS CRACKED / REMOVED & REPLACED R/W T/E VERTICAL SEAL RESTRAINER AT AFT PYLON TOP IAW SRM 51-40-02-0G-0 PARA 4. & FIG 8; & IPC 57-50-00-25. 55920U 09OCT18SDR SWAA2022022420966Nut Plate · corroded***CORROSION***ON NUTPLATE STRIP COMMON TO UNDERSIDE OF AFT CARGO BAY STRAP RBL 20 AT BS 787+6' / REMOVED AND REPLACED CORRODED NUTPLATE STRIP WITH NEW NUTPLATE STRIP PER SRM 51-40-02-0G-0 AND DWG 146A8340 SH. 22; NO ALLOWABLE DAMAGE LIMITS LISTED IN SRM; PARTSDR SWAA2018102226145Strap · corrodedAFT CARGO BAY STRAP CORRODED BETWEEN BS 794 TO BS 847, RBL 20. R&R STRAP IAW SRM AND DWG.SDR SWAA2018102226144Threshold · corrodedAFT CARGO BAY SUBTHRESHOLD WEB CORRODED BETWEEN BS 794 TO BS 847, BETWEEN RBL 22 TO RBL 24. R&R WEB IAW SRM AND DWG.SDR SWAA2018102226143Fitting · crackedAFT CARGO BAY FITTING CRACKED AT BS 947.5, LBL 10. R&R FITTING IAW DWG AND SRM.SDR SWAA2022022420939Angle · corroded***CORROSION*** ON FWD ENTRY DOOR THRESHOLD L ANGLE UPPER SURFACE FWD FASTENER HOLE; BS 338.5 / FWD ENTRY DOOR THRESHOLD L ANGLE IS BEING REPLACED ON DEFECT NO T848429SDR SWAA2018102226142Door Sill · crackedL1 DOOR MOPSILL CRACKED AT BS 303.9, WL 207.5. R&R MOPSILL PER SRM AND DWG.SDR SWAA2018102226141Angle · corrodedL1 DOOR THRESHOLD Z ANGLE UPPER SURFACE FORWARD FASTENER HOLE CORRODED AT BS 338.5. R&R Z ANGLE PER SRM & DWG.SDR SWAA2022022320925Skin · delaminated#6 SPOILER PANEL LOWER SURFACE HAS A DELAMINATED DENT 7.7' FROM I/B END AND 15.6' FROM AFT END / REPAIRED DELAMINATED DENT ON #6 SPOILER PANEL LOWER SURFACE 7.7' FROM I/B END AND 15.6' FROM AFT END PER SRM 51-70-10-2R-3 AND SRM 51-70-10-2R-0;SDR SWAA2022022320930Fairing · delaminatedWING TO BODY FAIRING #193AL HAS AREAS OF DELAMINATION ON OUTER SURFACE / WING TO BODY FAIRING #193AL WITH AREAS OF DELAMINATION ON OUTER SURFACE WAS REPAIRED PER SWA EA# 1-753-33475 REV IR DATED 27-OCT-2018 AND ATS ER# 18-04498 REV IR DATED 27-OCT-2018SDR SWAA2022022320932Balance Weight · corrodedRUDDER BALANCE WEIGHT IS ERODED. / RUDDER BALANCE WEIGHT REMOVED IAW CCM 55-40-09 PARA 2. C (2) PAGE 301 56790U 11OCT18 INSTALLED RUDDER BALANCE WEIGHT IAW CMM 55-40-09 PARA 2. C. (3) PAGE 701 56790U 12OCT18SDR SWAA2022022320933Nut Plate · corroded***CORROSION*** IN ACB UNDER NUTPLATE LOCATED AT 847+3 RBL 19 / NO ALLOWABLE DAMAGE LIMITS LISTED IN SRM; REMOVED CORRODED NUTPLATE STRIP AT B.S. 847+3 RBL 19; AND INSTALLED NEW NUTPLATE STRIP PER SRM 51-40-02-0G-0 AND DWG 146A0081 SH. 31.SDR SWAA2018102226140Floor Support · corrodedBULKHEAD TO FLOOR SUPPORT CORRODED AT BS 947, BETWEEN LBL 2 TO RBL 12. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2018102226139Shield · corrodedAFT CARGO BAY SHIELD AFT OF DOOR CORRODED BETWEEN BS 847 TO BS 867. R&R SHIELD IAW SRM AND DWG.SDR SWAA2018102226138Web · crackedRT WING FIXED TRAILING EDGE TRANSVERSE WEB CRACKED ON THE OUTBOARD END. R&R WEB IAW SRM.SDR SWAA2018102226136Door Sill · corrodedR2 DOOR MOPSILL CORRODED BETWEEN BS 896.5 TO BS 986.5. R&R MOPSILL PER SRM AND DWG.SDR SWAA2022022320899Beam · crackedDURING COMPLETION OF CCN: 14079 FOUND FORWARD SERVICE DOOR #4 BEAM TO BE CRACKED ON THE INBOARD SIDE OF THE RADIUS COMMON TO THE FORWARD MOST ATTACH POINT FOR THE DOOR HANDLE BOX ASSY. / FORWARD SERVICE DOOR #4 BEAM REPLACED ON COMPONENTS WO# 0520055-CHR.SDR SWAA2022022320903Intercostal · crackedCRACKED INTERCOSTAL AT B.S 344-360 R.B.L. 12; W.L. 208.1. / REMOVED AND INSTALLED A NEW INTERCOSTAL AT BS 344 - 360 RBL 12; WL 208.1 IAW SRM 51-40-02; DWG 141A5400SDR SWAA2018103026349Stiffener · crackedRT HORIZONTAL STABILIZER RIB STIFFENER CRACKED AT 3RD STIFFENER AFT, STAB STA 120.3. REPAIRED STIFFENER IAW SRM.SDR SWAA2018103026348Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, RBL 45. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2018102226135Support · corrodedLT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727E TO BS 847. R&R SUPPORT IAW SRM.SDR SWAA2018102226134Shield · corrodedAFT CARGO BAY SHIELD CORRODED BETWEEN BS 767 TO BS 792, RBL 24. R&R SHIELD IAW SRM AND DWG.SDR SWAA2018102226133Cargo Track · corrodedAFT CARGO TIE DOWN TRACK CORRODED AT BS 787+12 TO BS 887, RBL 13.8. R&R TIE DOWN TRACK SECTION PER DWG AND SRM.SDR SWAA2018102226131Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, LBL 12. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018102226130Support · corrodedFORWARD ENTRY DOOR CENTER SCUFF PLATE INBOARD SUPPORT CORRODED AT BS 338. R&R SUPPORT PER SRM.SDR SWAA2018102226129Attach Fitting · corrodedL1 DOOR GIRT BAR ATTACH FITTING CORRODED AT BS 312. R&R FITTING IAW SRM.SDR SWAA2018102226128Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 47. R&R INTERCOSTAL IAW DWG & SRM.SDR SWAA2018102226127Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 294 TO BS 312, RBL 20. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018102226126Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 TO BS 294, BL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2022022320890Skin · corroded***CORROSION*** FCB DOOR- CORROSION ON INTERNAL SKIN 1.25' FROM LWR EDGE; 2.75 FROM AFT EDGE. / FWD CARGO DOOR CORRODED INTERNAL SKIN IS REPAIRED ON CUSTOMER WORK ORDER # 510216SDR SWAA2018102226125Gusset · crackedFORWARD CARGO BAY RT UPPER GUSSET PLATE CRACKED AT BS 500D, STR 19R. R&R GUSSET IAW SRM AND DWG.SDR SWAA2018102226124Threshold · corrodedFORWARD CARGO BAY SUB-THRESHOLD WEB CORRODED. R&R SUB-THRESHOLD IAW SRM AND DWG.SDR SWAA2018102226100Shield · corrodedFORWARD CARGO BAY AFT FLOOR-TO-SIDEWALL SHIELD CORRODED BETWEEN BS 492 TO BS 500A, STR 26R. R&R SHIELD IAW DWG AND SRM.SDR SWAA2018102226099Support Angle · corrodedFORWARD CARGO BAY AFT FLOOR-TO-SIDEWALL SUPPORT ANGLE CORRODED AT BS 500D, BETWEEN LBL 19 TO RBL 20. R&R ANGLE IAW SRM AND DWG.SDR SWAA2018102226098Support · corrodedFORWARD CARGO BAY LT FLOOR-TO-SIDEWALL SUPPORT CORRODED BETWEEN BS 400 TO BS 500D, LBL 23. R&R SUPPORT IAW SRM & DWG.SDR SWAA2018102226097Fitting · crackedFORWARD CARGO BAY LT FORWARD FLOOR-TO-SIDEWALL SUPPORT CLIP CRACKED AT BS 400, STR 26L. R&R CLIP IAW DWG.SDR SWAA2022022320863Retainer · crackedLEFT WING T/E VERTICAL SEAL RETAINER AT AFT PYLON TIP IS CRACKED / REMOVED & REPLACED LEFT WING T/E VERTICAL SEAL RETAINER AT AFT PYLON TIP IAW SRM 51-40-02-0G-0 PARA 4 & FIG 8; & IPC 57-50-00-25. 55920U 08OCT18SDR SWAA2022022320864Scuff Plate · crackedFWD CARGO BAY AFT CORNER SCUFF PLATE CRACKED / REPAIRED AFT CORNER SCUFF PLATE IAW EA 1-A53-2076 REV:11 AT FCBSDR SWAA2022022320865Scuff Plate · crackedAFT CARGO BAY AFT CORNER SCUFF PLATE CRACKED / REPAIRED AFT CARGO BAY-AFT CORNER SCUFF PLATE PER EA# 1-A53-2076 REV:11SDR SWAA2018102226108Bulkhead · crackedLT MAIN LANDING GEAR WHEEL WELL LOWER COMPOSITE BULKHEAD CRACKED AT BS 663. REPAIRED BULKHEAD IAW SRM.SDR SWAA2018102226096Bulkhead · crackedRT MAIN LANDING GEAR WHEEL WELL BULKHEAD CRACKED AT BS 663. REPAIRED BULKHEAD IAW SRM.SDR SWAA2022022320841Panel · delaminatedLEFT WING LEADING EDGE PANEL 521KB DELAMINATED AT FWD EDGE AT CUTOUT / LEADING EDGE PANEL 521KB WITH DELAMINATION AT FWD CUTOUT WAS REPAIRED PER SRM 51-70-05-2R-6 58852U 10/15/18SDR SWAA2018090424706Plate · corrodedLAV SERVICE DOOR HINGE CLOSE OUT PLATE CORRODED. R&R PLATE IAW SRM AND DWG.SDR SWAA2022022220808Door · corroded***CORROSION*** TRANSFERRED FROM LOGBOOK PAGE #0743907 'AFT LAV SERVICE DOOR EVIDENCE OF CORROSION' / REMOVED CORRODED AFT LAV SERVICE DOOR + REPLACED WITH NEW AFT LAV SERVICE DOOR MPN 52410001-01 IAW AMM 52-49-07-400-801 + 52-49-07-000-802SDR SWAA2022021820798Wedge · delaminatedLEFT WING INBOARD MAIN FLAP TRAILING EDGE WEDGE HAS AN AREA THAT IS DELAMINATED. THE DELAMINATION IS 21' X 9' STARTING 7' FROM THE OUTBOARD EDGE ON THE LOWER SIDE OF WEDGE. / INSTALLED PANEL PER M/M REF. 20-50-11.SDR SWAA2018032720699Slide · looseR2 DOOR ESCAPE SLIDE LOOSE. SECURED THE SLIDE IAW AMM.SDR SWAA2018012319274Guard · brokenSWITCH GUARD SPRING BROKEN ON EMERGENCY LIGHT SWITCH AT AFT FLIGHT ATTENDANT STATION. R&R SWITCH GUARD PER SIP.SDR SWAA2017081815778Lens · brokenLEFT FORWARD ENTRY EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017081515586Lens · brokenLEFT EMERGENCY LIGHT LENS BROKEN BETWEEN ROWS 23 & 24. R & R THE LENS IAW AMM.
Back to N264LV