N425LV
Service difficulty reports · 272
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 = 'N425LV' 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 = 'N425LV' 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 SWAA2021060219916Insert · missingPASSENGER CABIN FLOOR PANEL; 242WF; HAS A MISSING INSERT. / PASSENGER CABIN FLOOR PANEL 242WF WITH A MISSING INSERT WAS REPLACED WITH A SERVICEABLE FLOOR PANEL DUE TO AMOUND OF ALL DAMAGE PER SRM 51-10-02-0G-0 PARA 9.A.(1).SDR SWAA2021040119902Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 221DF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 221DF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR.9SDR SWAA2021040119905Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 221AF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 221AF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR.9SDR SWAA2021040119907Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 222AF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 222AF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0; PAR 9.SDR SWAA2021040119910Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 242VF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 242VF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR.9SDR SWAA2021040119911Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 241ABF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 241ABF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR.9SDR SWAA2021040119913Floor Panel · damagedPASSENGER CABIN FLOOR PANEL; 241ADF; HAS DAMAGED INSERTS AROUND PERIPHERY OF PANEL. / DAMAGED FLOOR PANEL 241ADF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR 9SDR SWAA2021082319880Floor Support · crackedCRACKED INTERCOSTAL AT B.S. 312-328; W.L. 208.1; L.B.L. 47. / REMOVED AND REPLACED INTERCOSTAL AB BS 312-328 WL 208.1 LBL 47 IAW SRM 51-40-02-0G-0 AND BOEING DWG 141A5400SDR SWAA2021082319881Floor Support · crackedCRACKED INTERCOSTAL AT B.S. 328-344; W.L. 208.1; L.B.L. 47. / REMOVED AND REPLACED INTERCOSTAL AT BS 328-344. WL 208.1 LBL 47 IAW SRM 51-40-02-0G-0 AND BOEING DWG 141A5400SDR SWAA2021082319875Door Frame · crackedCRACK IN RADIUS OF FRAME AT B.S. 312; JUST ABOVE FORWARD ENTRY DOOR CUT OUT. / CRACK IN RADIUS OF FRAME @ BS 312 JUST ABOVE FORWARD ENTRY DOOR CUTOUT WAS NOTCHED OUT IAW EA 1-753-36506 REV IR DATED 02/24/2020 & ATS ER 20-01622 REV IR DATED 02/24/2020SDR SWAA2021081919878Channel · corroded***CORROSION*** ON FORWARD ENTRY DOOR MOP SILL AT B.S. 308-340; W.L. 208.1; L.B.L. 66. / REMOVED CORROSION ON FED MOPSILL BS 308-340 WL 208.1 LBL 66 32'X1'X.016'; ORIGINAL THICKNES .080' FOUND TO BE OUT OF LIMITS; REMOVED AND REPLACED FED MOPSILL IAW SRM 53-10SDR SWAA2021081919879Channel · corroded***CORROSION*** ON FORWARD SERVICE DOOR MOP SILL AT B.S. 294.5-328; W.L. 209; R.B.L. 58. / REPLACED; FWD. SERVICE DOOR MOP SILL AT B.S. 294.5- 328 WL 209; RBL 58 I.A.W. SRM 51-40-02-0G-0; 51-40-05-0G-0 AND DWG. 141A8310. 59868U FEB-18-20SDR SWAA2021081319847Strap · corroded***CORROSION*** 0N TENSION STRAP AT B.S. 1016 - 1030; R.B.L. 17; W.L. 208.1. / REMOVED; FABRICATED AND INSTALLED NEW TENSION STRAP ASSY OUT OF ITEM #7075T6 .050; LOT #1407842-2 AT B.S. 1016-1030; RBL 17; WL. 208.1 IAW SRM 53-70-51-01-1; SRM 53-70-51-1A-1; SRM SDR SWAA2021072219884Floor Support · crackedCRACKED FLOOR SUPPOR AT B.S. 344-360; W.L. 208.1; L.B.L. 11. / REMOVED AND REPLACED FLOOR SUPPORT (MACHINED INTERCOSTAL) AT BS 344-360; WL 208.1 LBL 11 IAW SRM 51-40-02-0G-0 AND BOEING DWG 141A5400SDR SWAA2021072219885Floor Support · crackedCRACKED FLOOR SUPPOR AT B.S. 344-360; W.L. 208.1; R.B.L. 12. / REMOVED AND REPLACED FLOOR SUPPORT (MACHINED INTERCOSTAL) AT BS 344-360; WL 208.1 RBL 12 IAW SRM 51-40-02-0G-0 AND BOEING DWG 141A5400SDR SWAA2021062919877Support Angle · corroded***CORROSION*** ON FORWARD ENTRY DOOR SCUFF PLATE INBOARD SUPPORT AT B.S. 314-340; W.L. 209; L.B.L. 66. / REMOVED CORROSION ON FED SCUFFPLATE I/B SUPPORT AREA 26'X1'X.012'; ORIGINAL THICKNESS .080'; FOUND TO BE OUT OF LIMITS; REMOVED AND REPLACED FED SUPPORT ASDR SWAA2021062919876Scuff Plate · corroded***CORROSION*** ON FORWARD ENTRY DOOR SCUFF PLATE CENTER SUPPORT AT B.S. 314-335; W.L. 209; L.B.L. 66. / REMOVED CORROSION ON FED SCUFFPLATE SUPPORT BS314-335 WL 209 LBL 66 AREA 21'X.9'X.010'; ORIGINAL THICKNESS .060'; FOUND TO BE OUT OF LIMITS; REMOVED AND RESDR SWAA2020030442092Skin · dentedEXTERNAL FUSELAGE SKIN HAS A DENT WITH A GOUGE AT BS 597+8.5", 2.4" BELOW STRINGER 1 R/H EXTERNAL FUSELAGE SKIN DENT WITH GOUGE @ B.S 597+8.5", 2.4" BELOW STR 1 R/H. WAS REPAIRED IAW EA 1-753-36629 REV IR DATED 02/26/2020 & ATS ER 20-01689 REV IR DATEDSDR SWAA2020022641735Floorbeam · corrodedFLOOR BEAM CORRODED AT BS. 986.5, BETWEEN LBL 47 TO RBL 47, UPPER SURFACE. / REPAIRED FLOOR BEAM IAW EA.SDR SWAA2020022641698Stub Frame · crackedR1 DOOR STUB FRAME CRACKED AT BS. 294.5, RBL 56. / R&R STUB FRAME IAW SRM AND IAW DWG.SDR SWAA2020022641697Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS. 344 TO BS. 360, RBL 35. / REPAIRED FLOOR SUPPORT IAW SRM.SDR SWAA2020022641696Attach Fitting · corrodedL1 DOOR ESCAPE SLIDE GIRT BAR AFT ATTACH FITTING CORRODED, UPPER SURFACE, AT BS. 344, LBL 64. / R&R FITTING IAW DWG AND SRM.SDR SWAA2020022654716Floorbeam · corrodedFLOOR BEAM, UPPER SURFACE, CORRODED AT BS. 328, BETWEEN RBL 30 TO RBL 55. / REPAIRED FLOOR BEAM UPPER CHORD IAW SRM & AMM.SDR SWAA2020022654695Shield · corrodedFORWARD CARGO BAY SHIELD CORRODED BETWEEN BS. 494 TO BS. 500A, RBL 24. / R&R SHIELD IAW SRM AND DWG.SDR SWAA2020022654694Support · corrodedFORWARD CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 400 TO BS. 500D, LBL 24. / R&R SUPPORT IAW SRM AND EA.SDR SWAA2020022094561Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 727 TO BS. 847, LBL 21. / R&R SUPPORT IAW SRM AND DWG.SDR SWAA2020021941529Shield · corrodedAFT CARGO BAY SHIELD CORRODED BETWEEN BS. 847 TO BS. 867, RBL 21. / R&R SHIELD IAW SRM AND DWG.SDR SWAA2020021941528Shield · corrodedFORWARD CARGO BAY SHIELD CORRODED BETWEEN BS. 420 TO BS. 440, RBL 24. / R&R SHIELD PER SRM AND DWG.SDR SWAA2020021981527Support · corrodedFORWARD CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 500A TO BS. 500D, RBL 24. / R&R SUPPORT IAW SRM.SDR SWAA2020021981526Web · corrodedFORWARD CARGO BAY SUB WEB THRESHOLD CORRODED BETWEEN BS. 440 TO BS. 494, RBL 28. / R&R WEB IAW SRM & DWG.SDR SWAA2020021941513Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 887 TO BS. 947, RBL 21. / R&R SUPPORT IAW SRM & DWG.SDR SWAA2020021941512Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 727 TO BS. 767, RBL 21. / R&R SUPPORT PER SRM AND DWG.SDR SWAA2020021941511Shield · corrodedAFT CARGO BAY SHIELD CORRODED BETWEEN BS. 767 TO BS. 794, RBL 21. / R&R SHIELD PER SRM AND DWG.SDR SWAA202108201269Radome · damagedRADOME HAS MULTIPLE FASTENER HOLES ELONGATED. / REMOVED AND REPLACED RADOME I.A.W CUSTOMER CARD NBR: 753-10-07 (POS: ONLY; TAGNO: 651156; P/N OFF/ON: 5214-100V4; S/N OFF: 065; S/N ON: 377)SDR SWAA2021070719820Skin · bentFWD CARGO DOOR EXTERNAL SKIN HAS A BENT LOCATED AT 4.5' FROM FWD EDGE; AND AT BOTTOM EDGE; BENT MEASURES L=1.7'; W=.6'. / FWD CARGO DOOR EXTERNAL SKIN HAS A BENT LOCATED @ 4.5' FROM FWD EDGE & AT BOTTOM EDGE BENT MEASURES L=1.7'; W=.6' DAMAGE REPAIRED/INSPECTESDR SWAA2021070719819Skin · bentFWD CARGO DOOR EXTERNAL SKIN HAS A BENT LOCATED AT FWD EDGE; AND 5' FROM BOTTOM EDGE; BENT MEASURES L=12.5'; W=.4'. / FWD CARGO DOOR EXTERNAL SKIN DENT LOCATED AT FWD; EDGE AND SILL FROM BOTTOM EDGE. DENT MEASURES L=12.5' W=4'. DAMAGE REPAIRED/INSPECTED & EVALSDR SWAA2020022541715Stiffener · crackedRIGHT HAND HORIZONTAL STABILIZER INSPAR RIB, AT STA. 120.30, 3RD VERTICAL STIFFENER WAS CRACKED. / REPAIRED 3RD VERTICAL STIFFENER IAW SRM.SDR SWAA2020022094560Bulkhead Web · crackedLOWER COMPOSITE BULKHEAD CRACKED AT BS. 663, RBL 56. / R&R VAPOR BARRIER PER SRM & DWG.SDR SWAA2019052933141Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT PER MM.SDR SWAA2022030142992Retainer · crackedLEFT WING BULB SEAL RETAINER ASSEMBLY CRACKED AFT OF #1 AFT STRUT / REPLACE LEFT WING BULB SEAL RETAINER ASSEMBLY AFT OF #1 AFT STRUT PER SRM 51-40-02.SDR SWAA2018122027708Support · crackedLT WING ANGLED WEB SUPPORT CRACKED INBOARD OF FLAP DEFLECTION BEAM. R&R SUPPORT PER SRM.SDR SWAA2018041821269Spring · missingAFT ENTRY CONTROL PANEL EMERGENCY EXIT LIGHT SWITCH COVER SPRING MISSING. R & R THE COVER PER SWPM.SDR SWAA2022021543101Scuff Plate · crackedFWD ENTRY DOOR; FWD CORNER SCUFF PLATE CRACKED AND BENT OUT OF SHAPE. / REMOVED AND REPLACED FWD CORNER SCUFF PLATE OF FWD ENTRY DOOR IAW AMM 25-27-21-000-801; AMM 25-27-21-400-801SDR SWAA2018041721244Sign · inoperativeR2 DOOR EMERGENCY EXIT SIGN BULB INOPERATIVE. R & R THE SIGN IAW AMM.SDR SWAA2018041221138Cargo Track · crackedAFT CARGO BAY RT FLOOR TRACK CRACKED BETWEEN BS 767 TO BS 887, RBL 14. R&R FLOOR TRACK PER SRM & DWG.SDR SWAA2022021043082None · crackedCLIP ON THE FWD SIDE OF THE BS 663 VAPOR BARRIER LBL25 WL 154 IS CRACKED / REMOVED CRACK DAMAGED CLIP ON FWD SIDE OF BS 663 LBL 25 WL 154 VAPOR BARRIER IAW SRM 51-40-02-0G-0 LOCATED AND DRILLED NEW CLIP IAW SRM 51-40-05-0G-0 OK TO INSTALL 13656R 07APR18 INSP 6SDR SWAA2018041721243Attach Angle · crackedBS 663 BULHEAD ATTACH ANGLE CRACKED, RBL 8. REPAIRED THE ATTACH ANGLE IAW ER AND EA.SDR SWAA2018041021062Bracket · crackedBULKHEAD EXHAUST DUCT BRACKET CRACKED AT BS 663, RBL 15. R & R THE BRACKET IAW SRM & DWG.SDR SWAA2022021043080Beam · crackedCRACK NOTED COMMON TO THE 141A6536-15 BEAM AT THE RADIUS. / 141A6536-15 BEAM OF FWD SERVICE DOOR REPLACED ON CUSTOMER RO # 0520055-BIRSDR SWAA2022021043081Beam · crackedCRACK NOTED COMMON TO THE 141A6536-14 BEAM AT THE RADIUS. / 141A6536-14 BEAM OF FWD SERVICE DOOR REPLACED ON CUSTOMER RO# 0520055-BIR
Back to N425LV