N757LV
Service difficulty reports · 283
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 = 'N757LV' 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 = 'N757LV' 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 SWAA2017100316853Crease Beam · corrodedR2 CREASE BEAM INNER CHORD CORRODED BETWEEN BS 955 TO BS 992, RBL 48. R&R CREASE BEAM IAW DWG AND SRM.SDR SWAA2017100316852Crease Beam · corrodedR1 CREASE CORRODED BETWEEN BS 312 TO BS 340 UPPER SURFACE. R&R CREASE BEAM IAW SRM & DWG.SDR SWAA2017100316851Support Angle · corrodedR1 DOOR LOWER SILL INNER THRESHOLD SUPPORT ANGLE CORRODED BETWEEN BS 294.5 TO BS 328, RBL 57. R&R STRAP IAW SRM & AMM.SDR SWAA2017100216813Floorbeam · corrodedAFT WET AREA T-CAP CORRODED AT BS 986.5, BETWEEN LBL 46 TO RBL 46, ON UPPER AND LOWER SURFACE. R&R T CHORD IAW SRM AND EA.SDR SWAA2017092116514Girt Bar · corrodedL1 DOOR FORE AND AFT GIRT BAR STRUCTURE CORRODED. R&R GIRT BAR ASSEMBLY IAW AMM.SDR SWAA2017092116513Intercostal · crackedINTERCOSTAL CRACKED AT BS 274+2, LBL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2022013185064Retainer · crackedRIGHT WING PANEL AFT OF PYLON; BULB SEAL BRACKET CRACKED AT LOWER BOLT. / REMOVED AND INSTALLED A NEW BULB SEAL BRACKET AT RIGHT WING PANEL AFT OF PYLON I/A/W B737 SRM 51-40-02-0G-0SDR SWAA2017101017003Stiffener · crackedLT BULKHEAD FORWARD SIDE, DIAGONAL ANGLE STIFFENER CRACKED AT BS 663. R&R STIFFENER IAW SRM AND DWG.SDR SWAA2017101017002Pressure Deck · crackedRT MAIN LANDING GEAR TOP PRESSURE DECK WEB CRACKED AT BS 663+2, RBL 41. REPAIRED WEB IAW EA.SDR SWAA2017101016952Pressure Panel · crackedLT MAIN LANDING GEAR TOP PRESSURE DECK CRACKED AT BS 663+1.5, LBL 31. REPAIRED WEB IAW EA.SDR SWAA2017100316850Angle · crackedRT ANGLE CRACKED AT BS 663. R&R ANGLE IAW DWG & SRM.SDR SWAA2017100316849Support Bracket · crackedLT WING TRAILING EDGE JUST BOARD OF FLAP DEFLECTION CONTROL RIB PANEL SUPPORT BRACKET CRACKED AT OUTBOARD END. R&R BRACKET IAW SRM AND DWG.SDR SWAA2017100316848Support Bracket · crackedLT WING TRAILING EDGE SUPPORT BRACKET CRACKED. R&R BRACKET IAW SRM AND DWG.SDR SWAA2017100216812Plate · crackedLT WING TRAILING EDGE ABOVE PYLON SAIL TAIL WIGGLE PLATE CRACKED AT FASTENERS. R&R WIGGLE PLATE ASSEMBLY IAW SRM.SDR SWAA2022011985049Panel · delaminatedMAIN WHEEL WELL PANEL 193B HAS A DENT WITH DELAM ON EXTERIOR SURFACE 7.5' FROM FORWARD EDGE AND 20.5' FROM RIGHT EDGE / REPAIRED MAIN WHEEL WELL PANEL 193 EXTERIOR SURFACE 7.5 ' FROM FORWARD EDGE AND 20.5 ' FROM RIGHT SIDE EDGE IAW SRM 51-70-04-2R-1 REV 62 PERSDR SWAA2017101016965Pressure Panel · crackedMAIN WHEEL WELL VERTICAL PRESSURE WEB CRACKED AT BS 663, LBL 42. REPAIRED WEB IAW SRM.SDR SWAA2017101016964Skin · crackedRT WING LEADING EDGE NR 8 SLAT LOWER SKIN AT ACTUATOR CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2017100616932Skin · crackedLT WING LEADING EDGE NR 2 SLAT LOWER SKIN AT ACTUATOR CRACKED. REPAIRED NR 2 SLAT PER SRM.SDR SWAA2017070314723O-Ring · failedNR 1 ENGINE, HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED. HYDRAULIC QUANTITY INDICATED AS LOW AS 7%. FOUND A BROKEN O-RING ON PRESSURE TRANSMITTER. R & R THE O-RING IAW AMM.SDR SWAA2017021311836Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017021311814Lens · looseL2 DOOR SLIDE LIGHT LENS LOOSE. R & R THE LENS IAW MT AND AMM.SDR SWAA2017021311813Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016101108577Bottle · low pressureL1 DOOR EMERGENCY EVAC SLIDE INDICATOR LOW PRESSURE. R & R THE SLIDE IAW MT.SDR SWAA2016071453776Charger · inoperativeL1 DOOR EXTERIOR EMERGENCY SLIDE LIGHT INOPERATIVE. R & R THE CHARGER IAW MM.SDR SWAA2016061652957Support Frame · crackedLEFT WING TO BODY PANEL 191L FORWARD SUPPORT FRAME CRACKED. R & R FRAME IAW SRM.SDR SWAA2016061652956Mount · looseR2 DOOR EMERGENCY EVAC SLIDE AFT SLIDE MOUNT LOOSE. R & R MOUNT IAW SRM.SDR SWAA2016032850234Lens · missingAFT GALLEY DOOR EXIT SIGN COVER MISSING. INSTALLED LENS IAW SIP.SDR SWAA2015111946218Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015112346365Rib · crackedLEFT HORIZONTAL STABILIZER RIB STATION 129.50, CRACKED AT 2ND STIFFENER. REPAIRED RIB IAW SRM.SDR SWAA2015112346364Rib · crackedLEFT HORIZONTAL STABILIZER RIB STATION 111.10, CRACKED AT 3RD STIFFENER. REPAIRED RIB IAW SRM.SDR SWAA2015120346694Rib · crackedRIGHT HORIZONTAL STABILIZER RIB 129.5, BOTTOM PORTION OF NR 3 STIFFENER CRACKED. R & R RIB IAW SRM.SDR SWAA2015120346693Rib · crackedRIGHT HORIZONTAL STABILIZER, RIB 120.3 BOTTOM PORTION OF NR 3 STIFFENER CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2015120346692Window Frame · crackedNUMBER 1 RT WINDOW FRAME CRACKED, AT OTBD UPPER CORNER. REPAIRED FRAME IAW ACO.SDR SWAA2015120446725Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8R. REPAIRED FRAME IAW EA & ER.SDR SWAA2015120346691Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015113046566Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA0300110146565Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015113046564Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015113046563Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015112346363Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346362Frame · crackedFRAME CRACKED AT BS 727A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346361Frame · crackedFRAME CRACKED AT BS 597, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346360Frame · crackedFRAME CRACKED AT BS 559, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346359Frame · crackedFRAME CRACKED AT BS 520, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346358Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346357Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015112346356Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015112346355Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015112346354Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015112346353Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.
Back to N757LV