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 SWAA2014042827409Post · crackedLEFT NR 3 FLIGHT DECK WINDOW E - F POST FOUND SECOND HOLE FROM THE BOTTOM CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014041727203Rib · crackedLEFT HORIZONTAL STABILIZER RIB STAB STATION 101.9 CRACKED AT LOWER INBD FLANGE JUST AFT OF FWD STIFFENER. REPAIRED RIB IAW EA.SDR SWAA2014041026984Attach Bracket · crackedRIGHT WING TE BEAM PANEL ATTACH BRACKET CRACKED AT BS 663. R & R BRACKET IAW SRM.SDR SWAA2014040826928Attach Bracket · crackedLEFT WING TRAILING EDGE BEAM PANEL ATTACH BRACKET CRACKED AT BS 663. R & R BRACKET IAW SRM.SDR SWAA2014040726872Strap · corrodedAFT CARGO BAY LOWER SURFACE OF STRAP CORRODED AT BS 792, RBL 20. R & R STRAP IAW SRM.SDR SWAA2014040726853Support · corrodedFORWARD CARGO BAY AFT BULKHEAD LOWER SUPPORT CORRODED AROUND FASTENER HOLES BETWEEN LBL 3 & RBL 20. R & R SUPPORT IAW SRM.SDR SWAA2014041026983Angle · crackedBULKHEAD ANGLE CRACKED AT BS 663, LBL 28. R & R ANGLE IAW SRM.SDR SWAA2014040726879Web · corrodedVERTICAL WEB CORRODED BETWEEN BS 787 TO BS 807, RBL 7. R & R WEB IAW SRM.SDR SWAA2014040726878Web · corrodedVERTICAL WEB CORRODED BETWEEN BS 767 TO BS 787, RBL 7. R & R WEB IAW SRM.SDR SWAA2014040326797Support Angle · corrodedFLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 727D - 727E, RBL 15. R & R PLATE IAW SRM.SDR SWAA2014040326796Support Angle · corrodedFLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 747 TO 767, RBL 15. R & R PLATE IAW SRM.SDR SWAA2014040326795Support Angle · corrodedFLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 747 TO 774, LBL 18. R & R PLATE IAW SRM.SDR SWAA2014041727202Panel · crackedFAIRING 191D CRACKED OUT FASTENER HOLE ON FWD EDGE. REPAIRED PANEL IAW SRM.SDR SWAA2014021125062Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013102821566Battery · failedLT EMERGENCY EXIT LIGHTS FAILED CAPACITY CHECK BETWEEN ROW 13 TO ROW 22. R & R BATTERY IAW AMM.SDR SWAA2013102821544Battery · failedFWD EMERGENCY EXIT LIGHTS FAILED CAPACITY CHECK. R & R BATTERIES IAW AMM.SDR SWAA2013102821519Battery · failedAFT EMERGENCY EXIT LIGHTS FAILED CAPACITY CHECK. R & R BATTERIES IAW AMM.SDR SWAA2013101721257Display · failedDIVERSION AT 390 FIRST OFFICER`S ND SCREEN WENT BLANK & SOON THEREAFTER FIRST OFFICER`S A'S CALLED TO LET US KNOW PASSENGERS COMPLAINING OF ELECTRICAL SMELL, CAPTAIN`S SIDE, AFT CABIN. R &R FIRST OFFICER`S DISPLAY UNIT IAW MM.SDR SWAA2013050215528Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER M/M.SDR SWAA2013032814207Door · crackedLEFT MLG INNER DOOR CRACKED AT FWD SIDE OF AFT HINGE. REPAIRED DOOR PER MM.SDR SWAA2013030613353Vapor Barrier · crackedFUSELAGE MAIN GEAR WHEEL WELL FORWARD LOWER VAPOR BARRIER IS CRACKED 11 INCHES FROM LOWER EDGE FORWARD OF PTU VALVE. REPAIRED BARRIER PER EA.SDR SWAA2013030613350Floor Support · crackedFLOORBOARD SUPPORT BETWEEN BS 344 TO 360 AT BL 0 IS CRACKED AT FORWARD AND AFT FLOORBOARD ATTACH FASTENERS. REMOVED AND REPLACED SUPPORT PER SRM.SDR SWAA2013030613376Vapor Barrier · crackedFUSELAGE MAIN GEAR WHEEL WELL FORWARD LOWER VAPOR BARRIER IS CRACKED 4 INCHES FROM LOWER EDGE AT CENTER VERTICAL SUPPORT. REPAIRED BARRIER PER EA.SDR SWAA2012121410642Skin · damagedFWD ENTRY DOOR LOWER HINGE CUTOUT DAMAGE REPAIRED PER EA 1-752-1297 AND REQUIRES NDT INSP. PERFORMED NDT INSP OF REPAIR AREA PER 737 NDT MANAUL PART 6 51-00-000 PROCEDURE 4, NO DEFECTS NOTED.SDR SWAA2012060404609Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MT.SDR SWAA2012051403945Sign · looseCENTER CABIN EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012050203628Lens · missingLT EMERGENCY LIGHT LENS MISSING AT ROW 1. INSTALLED LENS PER AMM.SDR SWAA2012041903239Wire · exposedEMERGENCY LIGHTS WIRE EXPOSED. RE-SECURED WIRE PER MM.SDR SWAA2012031602250Lens · missingEMERGENCY LIGHT LENS ON FLOOR MISSING AT 1 ABC. INSTALLED LENS PER MM.SDR SWAA118013Wire · exposedDURING SCHEDULED HC1 CHECK, FOUND LT EEPLS WIRES EXPOSED. REPAIRED WIRES PER MM.SDR SWAA117792Coffeemaker · faultyDURING FLIGHT, ELECTRICAL BURNINIG ODOR NOTED BY PILOTS AND FLIGHT ATTENDANTS, NO VISIBLE SMOKE. REMOVED AND REPLACED AFT NR 1 COFFEEMAKER PER MM.SDR SWAA116342Lens · brokenEEPLS LENS BROKEN AT ROW 11. REMOVED AND REPLACED LENS PER MM.SDR SWAA115652Engine · failedAIR TURNBACK, NR 1 ENGINE COMPRESSOR STALLED DURING CLIMBOUT FROM INITIAL TAKEOFF 1000FT. REMOVED AND REPLACED NR 1 ENGINE IAW MM.SDR SWAA113515Lens · missingFWD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA112424Cover · looseFWD EEPLS COVER LOOSE. REMOVED AND REPLACED END CAP ASSY PER MM.SDR SWAA112292Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER IN SPAR SKIN CRACKED AT STA 101.9. REPAIRED SKIN PER SRM.SDR SWAA112291Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER IN SPAR SKIN CRACKED AT STA 101.9. REPAIRED SKIN PER SRM.SDR SWAA111221Cover · missingEEPLS COVER MISSING AT ROW 1. REMOVED AND REPLACED COVER PER MM.SDR SWAA110119Light · looseEEPLS LOOSE. SECURED EEPLS PER MM.SDR SWAA104429Flap · delaminatedDURING SCHEDULED 8Y CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER MM.SDR SWAA104314Mount · crackedDURING SCHEDULED 8Y CHECK, FOUND OVERWING EMERGENCY EXIT LIGHT MOUNT CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA104278Flap · puncturedDURING SCHEDULED 8Y CHECK, FOUND RT WING I/B AFT FLAP PUNCTURED. REPAIRED AFT FLAP PER SRM.SDR SWAA103880Lens · brokenDURING SCHEDULED MV2 CHECK, FOUND EEPLS LENS BROKEN AT ROW 15. REMOVED AND REPLACED LENS PER MM.SDR SWAA097687Cover · crackedDURING SCHEDULED HC2 CHECK, FOUND LT EEPLS COVER CRACKED AT ROW 3. REMOVED AND REPLACED COVER PER MM.SDR SWAA097689Battery · dischargedDURING SCHEDULED HC2 CHECK, FOUND EMERGENCY EXIT LIGHT FAILED CAPACITY TEST. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA097688Hook · looseDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE COVER GIRT BAR HOOK LOOSE. REMOVED AND REPLACED HOOK PER SRM.SDR SWAA095412Light · fadedDURING SCHEDULED CV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT FADED. RELAMPED PER MM.SDR SWAA092370Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA090028Cover · looseEMERGENCY EXIT SIGN LIGHT COVER FELL OFF AT MID CABIN. SECURED COVER PER MM.SDR SWAA090003Cover · brokenR2 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to N425LV