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 SWAA107584Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 947.5, RBL 3.0. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA107583Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847, LBL 3.0. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA107582Angle · corrodedDURING SCHEDULED 24Y CHECK, FOUND ANGLE WEB CORRODED BETWEEN BS 904 TO BS 910, STR 17L. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA107521Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107520Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107519Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 12.50. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107518Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 732D, RBL 3. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107517Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 3. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107516Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 8.10. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107515Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 3. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107514Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 732D, LBL 8.10. REPAIRED CHANNEL PER SRM AND BAC DWG.SDR SWAA107513Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107512Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 739, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA107511Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 24R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107510Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107442Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107441Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 24R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107440Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107439Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 2L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107438Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107437Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 19L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107436Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 19R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107435Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 14R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107344Flashlight · brokenDURING SCHEDULED 24Y CHECK, FOUND FWD WALL OF LAVATORY EMERGENCY FLASHLIGHT BASE BROKEN. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA107343Flashlight · brokenDURING SCHEDULED 24Y CHECK, FOUND LT AFT EMERGENCY FLASHLIGHT BASE BROKEN. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA106011Light · inoperativeDURING SCHEDULED CV CHECK, FOUND AFT ENTRY EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA105804Charger · inoperativeDURING SCHEDULED MV1 CHECK, FOUND FWD EEPLS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA105581Sign · brokenDURING SCHEDULED MV2 CHECK, FOUND FWD ENTRY LOWER EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA104910Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT LOWER EEPLS LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA103905Sign · brokenFWD EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103633Light · brokenDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA103632Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND LT EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA103037Battery Pack · dischargedL1 & L2 DOORS EMERGENCY EXIT LIGHTS FAULTY. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA102524Lens · missingL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA102523Slide · out of positionDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA102448Wire · looseAFT EMERGENCY EXIT LIGHT INOP. SECURED WIRE PER MM.SDR SWAA102214Switch · inoperativeAFT F/A'S STATION EMERGENCY EXIT LIGHTS SWITCH INOP. REMOVED AND REPLACED SWITCH ASSY PER MM.SDR SWAA102103Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND R1 & L1 EMERGENCY FLOOR LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK ASSY PER MM.SDR SWAA100312Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA100175Charger · inoperativeDURING SCHEDULED 2HC2 CHECK, FOUND FWD RT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA097404Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA096805Sign · brokenDURING SCHEDULED MV1 CHECK, FOUND FWD ENTRY EMERGENCY EXIT VERTICAL SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096242Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD ENTRY LOWER LEVEL EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095601Wire · brokenDURING SCHEDULED SPV CHECK, FOUND RT EEPLS INOP AT ROW 23. FOUND BROKEN WIRE, REPAIRED PER WDM.SDR SWAA095600Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 520, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER ER.SDR SWAA095505Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ER.SDR SWAA095386Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095385Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 509C, STR 27R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA095384Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 510B, STR 27R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA095383Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 482, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N340LV