N340LV
Service difficulty reports · 436
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 = 'N340LV' 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 = 'N340LV' 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 SWAA2012110509074Fastener · missingFRAME INNER CHORD SUPPORT ANGLE FASTENER MISSING AT BS 348.2, STR 15L. INSTALLED FASTENERS IAW ER AND EA.SDR SWAA2012110509042Skin · crackedFUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT LOWER AFT CORNER AT BS 340.25, WL 209. REPAIRED SKIN PER ER AND EA.SDR SWAA2012111509384Seal · cracked(RIGHT WING) NR 5 FLAP TRACK FAIRING LOWER SPRING ANGLE ON A/C IS CRACKED. REMOVED NR 5 FLAP TRACK FAIRING LOWER SPRING SEAL ANGLE CRACKED, INSTALLED NEW SPRING SEAL IAW SOPM 20-50-01 STEP 7 89264U 10/29/12.SDR SWAA2012111509383Support Angle · cracked(RIGHT WING) NR 2 PYLON CORNER SUPPORT ANGLE CRACKED ABOVE SPRING DOOR. REMOVED & REPLACED (RIGHT WING) NR 2 PYLON CORNER SUPPORT ANGLE ABOVE SPRING DOOR IAW SRM 51-40-02-0G & 51-10-02-0G, STEP 8C. 84035U 24OCT12.SDR SWAA2012111509363Support Angle · cracked70.5 WING FWD FAIRING CLOSE OUT SUPPORT ANGLE CRACKED AT BS 540. REMOVED DAMAGED SEAL ANGLE, FORMED NEW ANGLE AND HEAT TREATED PER BAC SPEC. LOCATED AND DRILLED FINISHED ANGLE AND INSTALLED IAW BOEING DWG 69-61951 84840U 10-16-2012.SDR SWAA2012110509073Skin · crackedRIGHT WING NR 5 SLAT LOWER L/E SKIN CRACKED AT O/B END. REPAIRED SKIN IAW SRM.SDR SWAA2012102308692Skin · crackedLEFT WING NR 2 SLAT LOWER L/E SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2012110509041Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 125. REPAIRED SKIN PER EA.SDR SWAA2012102308774Pressure Panel · crackedLEFT NOSE LANDING GEAR WHEEL WELL PRESSURE WEB CRACKED AT BS 246.7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012100308235Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER AMM.SDR SWAA2012100308229Charger · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER AMM.SDR SWAA2012082006824Light · inoperativeFWD SERVICE EMERGENCY LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012061404907Garlock Seal · leakingDIVERSION - OIL LEAKED NR 1 ENGINE. REMOVED AND REPLACED GARLOCK SEAL ON GEARBOX.SDR SWAA2012051403938Floorbeam · crackedFLOORBEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM IAW EA AND AMM.SDR SWAA2012042503390Light · brokenR1 DOOR EMERGENCY LIGHT BULB BROKEN. REMOVED & REPLACED BULB IAW M/M.SDR SWAA2012042503392Skin · crackedFUSELAGE SKIN DELAMINATED BETWEEN BS 358 TO BS 360, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2012042503391Frame · crackedFRAME CRACKED AT BS 340, STR 16R. REPAIRED FRAME IAW SRM.SDR SWAA2012042403338Stringer Clip · damagedBS 340, STR 10R STRINGER CLIP DAMAGED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA2012040502827Slide · out of positionR2 DOOR SLIDE OUT OF POSITION. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA2012040202761Sign · inoperativeLEFT AFT SIDEWALL EMERGENCY EXIT SIGN LIGHT INOP. RELAMPED SIGN IAW AMM.SDR SWAA2012032802626Door Frame · crackedL1 DOOR AFT FRAME CRACKED IN RADIUS OF CUTOUT. REMOVED AND REPLACED DOOR ASSY PER AMM.SDR SWAA2012021701509Cover · missingL1 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED EMERGENCY LIGHT CHARGER BASE PER M/M.SDR SWAA2012021301353Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT. RE-INSTALLED SLIDE PER M/T.SDR SWAA118694Light · inoperativeL1 DOOR EXIT LIGHT INOP. REMOVED AND REPLACED EXIT LIGHT ASSY, BATTERY PACK & CHARGER PER MM.SDR SWAA118489Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA116706Charger · inoperativeDURING SCHEDULED 2HC1 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER ASSY PER MM.SDR SWAA116013Slide · low pressureDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA114559Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REPAIRED LENS PER EA.SDR SWAA114530Cover · missingL2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. RE-INSTALLED COVER PER MM.SDR SWAA112399Light · brokenL1 DOOR LOWER EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA111125Plate · obstructedR1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR ATTACH PLATE STIFF. REMOVED FOD FROM PLATE ASSY PER MM.SDR SWAA110517Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA107739Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 9 SPOILER UPPER SKIN DELAMINATED. REMOVED AND REPLACED NR 9 SPOILER PER MM.SDR SWAA107738Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 7 SPOILER UPPER SKIN DELAMINATED. REMOVED AND REPLACED NR 7 SPOILER PER MM.SDR SWAA107737Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 671, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA107736Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT PRESSURE BULKHEAD LOWER LOBE STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED STIFFENER PER ACO.SDR SWAA107735Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT PRESSURE BULKHEAD LOWER LOBE STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED STIFFENER PER ACO.SDR SWAA107734Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 662.5, LBL 24.5. REPAIRED CHORD PER EA.SDR SWAA107733Battery Pack · dischargedDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA107732Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD PRESSURE DOME WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB PER EO AND EA.SDR SWAA107731Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA107730Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD PRESSURE DECK ANGLE STIFFENER CORRODED AT BS 1016, BETWEEN STR 27L TO STR 27R. REPAIRED STIFFENER PER EO.SDR SWAA107677Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500B, STR 27R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107658Lens · brokenDURING SCHEDULED 24Y CHECK, FOUND EMERGENCY EXIT SIGN LENS BROKEN ON SIDEWALL PANEL. REMOVED AND REPLACED SIGN PER MM.SDR SWAA107590Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 15R. REPAIRED WEB PER SRM.SDR SWAA107589Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 7L. REPAIRED WEB PER SRM.SDR SWAA107588Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 15L. REPAIRED WEB PER SRM.SDR SWAA107587Stringer Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CHANNEL CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CHANNEL PER SRM AND BAC DWG.SDR SWAA107586Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 27L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107585Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.
Back to N340LV