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 SWAA2015112346352Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015112346351Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015111846111Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015111846110Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015102145207Battery Pack · failedFORWARD LT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW MM.SDR SWAA2015102145203Battery Pack · failedAFT LT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW MM.SDR SWAA2015091043687Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2015070841497Bumper · missingR2 DOOR SLIDE COVER AFT END CAP BUMPER MISSING. INSTALLED BUMPER IAW AMM.SDR SWAA2015052740075Light · inoperativeLEFT EGRESS LIGHTS INOPERATIVE AT BELLY FAIRING. RELAMPED LIGHT IAW AMM.SDR SWAA2015052740067Light · inoperativeRIGHT EGRESS LIGHTS INOPERATIVE AT BELLY FAIRING. RELAMPED LIGHT IAW AMM.SDR SWAA2015041338474Lens · brokenRIGHT OVERWING EMER EXIT LENS BROKEN. R & R LENS IAW SIP.SDR SWAA2015030637178Light · inoperativeLEFT OVERWING EXIT SIDEWALL LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014103033570Holder · lack of lubeR2 DOOR EMER EVAC SLIDE GIRT BAR HOLDER AT AFT SERVICE DOOR STICK. LUBED GIRT BAR HOLDER IAW SIP.SDR SWAA2014091531986Lens · missingMID CABIN EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2014050727767Lens · unsecureR2 DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014042127252Guide Arm · out of adjustR2 DOOR EMERGENCY EXIT DOOR OUT OF ADJUSTMENT. ADJUSTED GUIDE ARM IAW MM.SDR SWAA2014012724559Fitting · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET CLIPS LOOSE. SECURED CLIPS IAW SIP.SDR SWAA2013110421784Skin · crackedSKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW EA.SDR SWAA2013110421783Beltframe · crackedBELT FRAME CRACKED AT STATION 727D, STRINGER 9R. REPAIRED FRAME IAW SRM.SDR SWAA2013110421782Seat Track · crackedSEAT TRACK INBD FLANGE AFT HOLES CRACKED AT STATION 727B, RBL 45.50. REPAIRED TRACK IAW EA.SDR SWAA2013110421781Seat Track · crackedSEAT TRACK OTBD FLANGE FWD HOLES CRACKED AT STATION 727B, RBL 45.50. REPAIRED TRACK IAW EA.SDR SWAA2013110421780Seat Track · crackedSEAT TRACK OTBD FLANGE FWD HOLES CRACKED AT STATION 727B, RBL 24.75. REPAIRED TRACK IAW EA.SDR SWAA2013110421779Seat Track · crackedSEAT TRACK INBD FLANGE AFT HOLES CRACKED AT STATION 727B, LBL 45.50. REPAIRED TRACK IAW EA.SDR SWAA2013110421778Seat Track · crackedSEAT TRACK OTBD FLANGE FWD & AFT HOLES CRACKED AT STATION 727B, LBL 45.5. REPAIRED TRACK IAW EA.SDR SWAA2013110421777Seat Track · crackedSEAT TRACK INBD FLANGE AFT HOLES CRACKED AT STATION 727B, LBL 24.75. REPAIRED TRACK IAW EA.SDR SWAA2013110421776Seat Track · crackedSEAT TRACK OTBD FLANGE FWD & AFT HOLES CRACKED AT STATION 727B, LBL 24.75. REPAIRED TRACK IAW EA.SDR SWAA2013110722029Window Frame · crackedLT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013110421773Skin · crackedRT WING NR 7 SLAT LOWER LE SKIN CRACKED AT ACTUATOR FITTING. R & R SKIN IAW MM.SDR SWAA2013110421772Skin · crackedLT WING NR 1 SLAT LOWER LE SKIN CRACKED AT ACTUATOR FITTING. R & R SKIN IAW MM.SDR SWAA2013110421775Window Frame · crackedLT NR 3 WINDOW FRAME E-F FASTENER HOLE NR 8 CRACKED AT 10:00 & 4:00 O'CLOCK LOCATION. REPAIRED HOLE IAW EA.SDR SWAA2013110421774Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN PANEL CRACKED AT STATION 129.5 INBD SIDE OF RIB 10.5" FWD OF REAR SPAR. REPAIRED SKIN IAW SRM.SDR SWAA2013040814541Skin · delaminatedLEFT WING O/B AFT FLAP LOWER I/B END UPPER SKIN DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA2013040814540Skin · delaminatedLEFT WING O/B AFT FLAP I/B TRAILING EDGE LOWER SKIN DELAMINATED. REMOVED AND REPLACED AFT FLAP PER M/M.SDR SWAA2013040814539Retainer · crackedLEFT WING I/B FIXED UPPER T/E FORWARD SEAL RETAINER CRACKED. REMOVED AND REPLACED SEAL RETAINER PER SRM.SDR SWAA2013040814538Retainer · crackedLEFT WING I/B FIXED UPPER T/E AFT SEAL RETAINER CRACKED. REMOVED AND REPLACED SEAL RETAINER PER MM.SDR SWAA2012092007810Light · inoperativeL1 DOOR EMERGENCY EXTERIOR LIGHT INOP. RELAMPED LIGHT ASSY IAW MM.SDR SWAA2012090607400Flap · delaminatedLEFT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW EA.SDR SWAA2012041803208Slide · out of positionR2 DOOR ESCAPE SLIDE HAS EXCESSIVE GIRT EXPOSED OUT OF SLIDE COVER. RE-INSTALLED R2 SLIDE PER M/M.SDR SWAA2012041803207Cover · out of positionR1 DOOR ESCAPE SLIDE GIRT PULL HANDLE COVER OUT OF POSITION. REPOSITIONED COVER PER M/M.SDR SWAA120586Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA118642Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA118491Battery Pack · failedDURING SCHEDULED 12Y CHECK, RT AFT CABIN EMERGENCY EXIT LIGHT BATTERIES FAILED CAPACITY TEST AT STA 603. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA118490Battery Pack · failedDURING SCHEDULED 12Y CHECK, RT MID CABIN EMERGENCY EXIT LIGHT BATTERIES FAILED CAPACITY TEST AT STA 603. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA118360Lens · crackedDURING SCHEDULED 12Y CHECK, FOUND LT SIDEWALL EMERGENCY EXIT LIGHT LENS CRACKED. R&R LENS PER MM.SDR SWAA118219Attach Angle · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX BULKHEAD ATTACH ANGLE CRACKED AT BS 540, LBL 15. REMOVED AND REPLACED ANGLE PER ACO.SDR SWAA116402Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EVAC EXTERIOR SLIDE LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA113941Light · inoperativeDURING SCHEDULED MV2 CHECK FOUND, RT OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 18. RELAMPED PER MM.SDR SWAA112018Cover · missingRT EEPLS COVER MISSING. SECURED COVER PER MM.SDR SWAA102325Hmu · faultyAIR TURNBACK, NR 1 ENGINE COMPRESSOR STALLED. REMOVED AND REPLACED NR 1 ENGINE HMU PER MM.SDR SWAA096856Cover · brokenFWD EEPLS COVER BROKEN. REMOVED AND REPLACED COVER PER MM.
Back to N757LV