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 SWAA2022021043070Panel · crackedLT HORIZ. STAB PANEL 334GB IS CRACKED. / RECEIVED SERVICEABLE L/H HORIZONTAL STAB PANEL 334GB LOCATED INSTALLATION HOLES IAW SRM 51-40-05-0G-0 PAR. 4 FIGURE 9; PANEL TO BE INSTALLED ON JPANEL-334-CLOSE CARD. 57048U 06APR18SDR SWAA2018041621202Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2022021043059Seal · crackedLT HORIZ. STAB FWD UPPER SLIDE SEAL IS CRACKED. / REMOVED & REPLACED LH H. STAB FWD UPPER SLIDE SEAL IAW SRM 51-40-02; IPC 53-31-31-03 & AMM 53-31-31-400-801SDR SWAA2018041621189Hanger Assy · looseL1 DOOR ESCAPE SLIDE AFT GIRT BAR HANGER LOOSE. R & R THE HANGER IAW SRM.SDR SWAA2022021043045Former · crackedR/H FAIRING FORMER AT BS.500D JUST ABOVE STR.19R IS CRACKED / REMOVED CRACKED R/H FAIRING FORMER AT BS 500D JUST ABOVE STR 19R PER SRM 51-40-02-0G-0. LOCATED; DRILLED; DEBURRED NEW FAIRING FORMER PER SRM 51-40-05-0G-0 AND DRAWING 116A3118. OK TO INSTALL. 3573CSDR SWAA2018041721242Skin · corrodedCROWN SKIN AT DORSAL FIN AREA CORRODED BETWEEN BS 887 TO 1007. R & R THE SKIN IAW ER AND EA.SDR SWAA2018041621180Fastener · damagedR2 DOOR ESCAPE SLIDE ASSEMBLY MOUNTING FASTENERS DAMAGED. R & R THE MOUNTING FASTENERS IAW MT.SDR SWAA2018041221137Pressure Panel · crackedPRESSURE WEB CRACKED AT BS 666, RBL 43. REPAIRED WEB PER EA.SDR SWAA2022021043017Scuff Plate · crackedAFT CARGO BAY; CENTER THRESHOLD SCUFF PLATE IS IS CRACKED AND MISSING / REMOVED AFT CARGO BAY CENTER THRESHOLD SCUFF PLATE PER MM 53-11-02-020-801 4566C 30MAR18; OK TO INSTALL NEW CENTER THRESHOLD SCUFF PLATE 3573C 09APR18 INSP 317 09APR18 INSTALLED NEW CENTERSDR SWAA2022021043018Scuff Plate · crackedAFT CARGO BAY; AFT CORNER SCUFF PLATE IS CRACKED / REMOVED AFT CARGO BAY AFT CORNER SCUFF PLATE PER: AMM 53-11-02-020-801 4369R 26MAR18. AFT CARGO BAY AFT CORNER SCUFF PLATE WAS REPAIRED PER EA# 1-A53-2076; REV 11 OK TO INSTALL AFT CORNER SCUFF PLATE. 3573C 09SDR SWAA2018041021060Tee Fitting · crackedKEEL BEAM PANEL TEE FITTING CRACKED AT BS 551, RBL 6. R & R THE TEE FITTING IAW MM.SDR SWAA2018041021059Bulkhead Web · crackedLOWER BULKHEAD WEB CRACKED AT BS 663, BETWEEN LBL 10 TO 15. REPAIRED THE BULKHEAD WEB IAW SRM.SDR SWAA2018041021058Bulkhead Web · crackedLOWER BULKHEAD WEB CRACKED AT BS 663, BETWEEN RBL 10 TO 15. REPAIRED THE BULKHEAD WEB IAW SRM.SDR SWAA2018011619015Strap · brokenAFT GALLEY FLASHLIGHT SECURE STRAP BROKEN. R & R THE FLASHLIGHT STRAP IAW SIP.SDR SWAA2017092716660Slide · looseR1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MT.SDR SWAA2017082115810Intercostal · crackedFLOOR BOARD SUPPORT FRAME CRACKED BETWEEN BS 312 TO BS 328, 48" LEFT OF CENTER. R&R INTERCOSTAL PER SRM.SDR SWAA2017082115809Support · crackedFLOOR BOARD SUPPORT FRAME CRACKED BETWEEN BS 344 TO BS 360. R&R SUPPORT PER SRM.SDR SWAA2017082115808Skin · crackedLT WING NR 3 SLAT LEADING EDGE LOWER SKIN CRACKED, AT THE ACTUATOR MOUNT FASTENER, CRACKED PROTRUDING FROM THE AFT INBOARD FASTENER. R&R NR 3 SLAT PER AMM.SDR SWAA2017082115807Skin · crackedLT WING NR 2 SLAT LEADING EDGE LOWER SKIN CRACKED AT THE ACTUATOR MOUNT FASTENER. R&R NR 2 SLAT PER AMM.SDR SWAA2017042613382Lens · looseFORWARD ENTRY LOWER EMERGENCY EXIT LENS LOOSE. R & R THE SIGN IAW AMM.SDR SWAA2016102108970Cover · detachedL1 DOOR LOWER EXIT SIGN COVER DETACHED. ATTACHED THE COVER IAW AMM.SDR SWAA2016051951928Slide · looseR2 DOOR EMER SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2016050951619Cover · missingRIGHT OVERWING EMER EXIT DOOR MISSING LOWER STRAP COVER. INSTALLED COVER IAW MM.SDR SWAA2016010747784Module · faultyAIR TURN BACK, LG LEVER WOULD NOT MOVE UP AFTER TAKEOFF. NO WARNING HORN SOUND. R & R LG CONTROL LEVER MODULE IAW MM.SDR SWAA2015092544271Pressure Panel · crackedMAIN WW CRACKED AT BS 663.75, RBL 35. REPAIRED WEB IAW SRM.SDR SWAA2015092444231Pressure Panel · crackedMAIN WW WEB CRACKED AT BS 663.75, RBL 43.3. REPAIRED WEB IAW SRM.SDR SWAA2014042827471Beam · crackedLONGITUDINAL BEAM CRACKED AT BS 727A+17.5, LBL 47. REPAIRED BEAM IAW EA.SDR SWAA2014042827470Beam · crackedLONGITUDINAL BEAM CRACKED AT BS 727A+16.5, LBL 26.25. REPAIRED BEAM IAW EA & ER.SDR SWAA2014042827469Beam · crackedLONGITUDINAL BEAM CRACKED AT BS 727A+17.5, RBL 23.25. REPAIRED BEAM IAW EA.SDR SWAA2014042827468Beam · crackedLONGITUDINAL BEAM CRACKED AT BS 727A+17.5, RBL 44. REPAIRED BEAM IAW EA & ER.SDR SWAA2014042827413Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED IN UPPER AFT CORNER. REPAIRED FRAME IAW ACO, ER, & EA.SDR SWAA2014042827412Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED AT BS 727E+2, WL 208. REPAIRED WEB IAW DWG & SRM.SDR SWAA2014042227290Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014042227289Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014042227288Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014042227287Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014042227286Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014042227285Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014042227284Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014042227283Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014041727204Frame · crackedLEFT FRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014041026985Support Bracket · crackedBULKHEAD SUPPORT BRACKET CRACKED AT BS 663, LBL 28. R & R BRACKET IAW SRM.SDR SWAA2014042827411Structure · corrodedUPPER CHORD CORRODED AT BS 986, BETWEEN LBL 14 TO RBL 40. REPAIRED CHORD IAW EA & ER.SDR SWAA2014042227282Floorbeam · brokenFLOOR SUPPORT BROKEN AT BS 540, BETWEEN RBL 45 TO RBL 65. R & R SUPPORT IAW SRM & DWG.SDR SWAA2014042227281Web · corrodedFLOOR WEB CORRODED AT BS 988, RBL 39. R & R WEB IAW SRM.SDR SWAA2014042827467Pressure Panel · crackedMAIN WW VERTICAL SPAR PRESS WEB CRACKED AT BS 663, LBL 35. REPAIRED WEB IAW ER & EA.SDR SWAA2014042127240Rib · crackedRIGHT HORIZONTAL STABILIZER LE PANEL 341B 4TH RIB OUT FROM INBD END CRACKED AT END IN RADIUS. R & R RIB IAW SRM.SDR SWAA2014041427132Spring · crackedHORIZONTAL CROSS CHANNEL SPRING CRACKED AT LT & RT SIDES JUST AFT & ABOVE VERTICAL STABILIZER FWD ATTACH POINTS. R & R SPRING IAW SRM.SDR SWAA2014040726831Rib · crackedRT HORIZONTAL STAB RIB AT STAB STATION 92.70 CRACKED IN 2ND & 3RD VERTICAL STIFFENERS. REPAIRED RIB IAW SRM.SDR SWAA2014042827410Post · crackedRIGHT NR 3 FLIGHT DECK WINDOW E - F POST FOUND SECOND HOLE FROM THE BOTTOM CRACKED. REPAIRED POST IAW ACO.
Back to N425LV