N246LV
Service difficulty reports · 322
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 = 'N246LV' 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 = 'N246LV' 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 SWAA2022122885320Guard · looseAFT EMERGENCY LIGHT SWITCH GUARD FELL OFF. REPLACED SWITCH GUARD IAW CMM 33-11-05.SDR SWAA2022082244273Tailpipe · flamed outINFORMED BY AIRCRAFT BEHIND THAT WE HAD A TAILPIPE FIRE ON ENGINE #2. ENGINE PARAMETERS WERE NORMAL; ENGINE WAS SHUT DOWN. / [01] C/W AMM 05-51-49-201-001; CONDITIONAL INSPECTION FOR TAILPIPE FIRES. REMOVED OIL ACCUMULATED IN CENTER PLUG CAVITY. PERFORMED #2 ESDR SWAA2022042797521Ballast · inoperativeLEFT EMERGENCY DOOR FLUORESCENT LIGHT INOP. / [01] REMOVED AND REPLACED LEFT EMERGENCY EXIT DOOR BALLAST; REF. AMM 52-22-51. FLUORESCENT LIGHT OPS CHECKED GOOD; REF; AMM 33-20-00.;[02] INSPECTEDSDR SWAA2022042797396Lamp · missingFWD SERVICE DOOR LOWER EMERGENCY LIGHT LENS MISSING DIRECTIONAL ARROW / [01] REMOVED AND REPLACED EMERGENCY EXIT LAMP ASSY AND DIRECTIONAL SIGN REF AMM 33-51-01;[02] INSPECTEDSDR SWAA2022041890996Scuff Plate · crackedAFT CARGO DOOR AFT CORNER SCUFFPLATE CRACKED / [01] RECEIVED REPAIRED AFT CARGO DOOR;AFT CORNER SCUFF PLATE;INSTALLATION IS ACCOMPLISHED ON CARD TTG8Q003BBRX;[02] VERIFIED STEP 1.SDR SWAA2022041890995Web · corrodedCORROSION>>>>> FWD E&E COMP INTERCOSTAL CORRODED AT BILGE AREA BS 360 LBL-10 / [01] REMOVED INTERCOSTAL WEB AT FWD E&E COMP STA 360 FOR ACCESS TO REWORK CORROSION PER REF B737-700 SRM 51-40-02-0G-0.;[02] EVALUATED DAMAGE WEB; FOUND EXFOLIATING CORROTION; CORROSDR SWAA2022041888872Gusset · crackedFWD CARGO COMP R/H SIDEWALL STRUCUTURE; GUSSET ANGLE CRACKED AT FRAME BS 500D STGR 19R / [01] REMOVED FWD CARGO COMPT. GUSSET ANGLE AT B.S.500D;STR 19R.REF.B737-700 SRM 51-4-02-0G-0;[02] VERIFIED 1;OK TO INSTALL NEW GUSSET ANGLE AT FWD CARGO COMT BS 500D STR 1SDR SWAA2022041888873Gusset · crackedFWD CARGO COMP L/H SIDEWALL STRUCUTURE; GUSSET ANGLE CRACKED AT FRAME BS 500D STGR 19L / [01] REMOVED AND REPLACED FWD CARGO COMP L/H SIDEALL STRUCTURE GUSSET ANGLE AT FRAME BS 500D STGR 19L IAW B737-700 SRM 51-40-02;[02] C/WSDR SWAA2022041886862Stringer · corrodedCORROSION>>>> FWD E&E COMP BILGE AREA STA 360 HAS STGR 28L CORRODED .MKD 126-1 / [01] REMOVED DAMAGE SPLICE AND DAMAGE ANGLE SPLICE FOR ACCESS TO REMOVE CORROSION ON STG 28L STA 360 PER REF B737-700 SRM 51-40-02-0G-0.;[02] EVALUATED CORROSION ON STG 28L STA 36SDR SWAA2022041885526Scuff Plate · crackedFWD CARGO DOOR CUTOUT FWD SCUFF PLATE CRACKED / [01] NEW FWD CARGO DOOR FWD SCUFF PLATE WILL BE INSTALLED ON WORK CARD TTG8Q003BBSV;[02] VERIFIED STEPSDR SWAA2022041885134Channel · crackedR/H Z CHANNEL AT AFT CARGO COMP R/H FROM STA 747 - 5' FOUND A CRACK. / [01] THIS ZEE CHANNEL FOUND CORROSION OUT OF LIMITS IN CARD TTG8Q008BD10X. AND ORDEN NEW PARTS ON THE SAME CARDS.;[02] VERIFIED STEP 1.SDR SWAA2022041885522Angle · crackedLT VERTICALSTAB ACCESS PANEL 323BL;SHOWS AFT CLOSURE ANGLE CRACKED AT FWD LWR AREA / [01] REMOVED AND REPLACED LT VERTICAL STAB. ACCESS PANEL 323BL AFT CLOSURE ANGLE PER REF B737-700 SRM 51-40-02-0G-0 AND DWG 172A6121.;[02] VERIFIED STEP 1.SDR SWAA2022041885133Channel · corrodedZ CHANNEL AT AFT CARGO COMP R/H FROM STA 727D TO STA 767 FOUND CORROSION AROUND THE MANY NUTPLATE / [01] REMOVED CORROSION AT AFT CARGO COMP R/H ZEE CHANNEL FROM STA 727D TO STA 767 .CORROSION PASS THRU; FOUND TO BE OUT OF LIMITS PER REF SRM 51-10-02-0G-0.;[02SDR SWAA2022041885120Scuff Plate · crackedFWD CARGO DOOR CUTOUT AFT SCUFF PLATE CRACKED / [01] NEW FWD CARGO DOOR AFT SCUFF PLATE WILL BE INSTALLED ON WORK CARD TTG8Q003BBSV;[02] VERIFIED STEPSDR SWAA2022041885121Beam · crackedCRACK FOUND AT FWD SERVICE DOOR NO.4 BEAM P/N: 141A6536-14 (REQUEST AS WRITTEN EO 5241-C-14093 OR 5241-C-14344 ) / [01] REMOVED FWD SERVICE GALLEY DOOR HANDLE BOX ASSEMBLY REF 737-700 CMM 52-41-05;[02] REMOVED #4 BEAM FROM FWD SERVICE DOOR IN REFERENCE WITH B7SDR SWAA2022041885124Panel · damagedREF TTG8Q003883M: LOWER WING TO BODY FAIRING 193D INNER SURFACE WITH FRETTING / [01] CLEANED DAMAGE AREA AND REPAIRED SMALL AREA OF FRETTING ON INNER SURFACE AFT AREA OF LOWER WING TO BODY FAIRING #193D AS PER B737 SRM 51-70-05-2R-8. MATERIALS USED PO#1759850 SDR SWAA2022041885125Panel · elongatedREF TTG8Q003883M: LOWER WING TO BODY FAIRING 193D WITH MULTIPLE FASTENER HOLES ELONGATED / [01] ACCOMPLISH A PERMANENT REPAIR ON DAMAGE FASTENER HOLES ON NON ROUTINE TTG8Q00BCUSS;[02] VERIFIED 1;COMPLETESDR SWAA2022041885123Fairing · crackedREF TTG8Q003883M: LOWER WING TO BODY FAIRING 193D WITH MULTIPLE FASTENER HOLES CRACKED / [01] CLEANED FAIRING PANEL 193D FOR REPAIR AND PERFORMED DRY OUT; FOUND NO WATER AS PER B737 SRM 51-70-05-2R-8;[02] VERIFIED 1;OK TO INSTALL REPAIR;[03] REPAIRED ALL DAMAGSDR SWAA2022041885126Panel · elongatedREF TTG8Q003883M: LOWER WING TO BODY FAIRING 194E WITH MULTIPLE FASTENER HOLES ELONGATED / [01] PERFORMED VISUAL INSPECTION AT PANEL 194E ON ALL FASTENER HOLE FOUND MULTIPLE DAMAGED PER B737 NTM 51-05-01 AND PREPARED DAMAGED AREA TO APPLY DRY PROCESS PER B737 SDR SWAA2022041883703Bulkhead Web · crackedAFT CARGO COMP. FWD BULKHEAD PANEL 142NW IS CRASKED. / [01] RECEIVED NEW AFT CARGO FWD BULKHEAD PANE 142NW; INSTALLATION PANEL IS ACCOMPLISHED ON CARD TTG8Q00AGZJS.;[02] VERIFIED STEP 1.SDR SWAA2022041883704Floor Panel · crackedAFT CARGO COMP. DOOR FWD CUTOUT PANEL 142KW IS CRACKED. / [01] RECEIVED NEW PANEL 142KW AT CARGO COMP FWD DOOR CUT OUT; PANEL INSTALLATION IS ACCOMPLISHED ON CARD TTG8Q003BETV.;[02] VERIFIED STEP 1.SDR SWAA2022041884104Floor Panel · crackedFWD CARGO COMPARTMENT FLOOR LINER 120AF CRACKED / [01] FABRICATED NEW FWD CARGO COMPARTMENT SIDEWALL LINER120AF IN RF B737-700 AMM 25-52-01-201-801;[02] VERIFIED STEP 1.SDR SWAA2022041883695Frame · looseR-1 DOOR UPPER PLATE LOOSE UPPER HINGE CUTOUT / [01] REMOVED FWD GALLEY SERVICE DOOR REF B737-700 AMM 52-41-00-000-801;[02] REMOVED AND REPLACED UPPER AND LOWER BEARING PLATES ASSEMBLY REF B737-800 SRM 51-40-02-0G-0 AND SOPM 20-50-03;[03] VERIFIED 1 AND 2;COMPSDR SWAA2022041883689Skin · crackedCRACK FOUND AT LEFT HORIZONTAL STABILIZER LOWER SKIN STAB STA 193.90 ;15.5' FROM FRONT SPAR AT I/B FASTENER ROW. CRACK LENGTH 1'. CRACK FOUND AT LEFT HORIONTAL STABILIER LOWER SKIN STAB STA 193.90 15.5' FROM FRONT SPAR AT I/B FASTENER ROW. CRACK LENGTH 1'. / [SDR SWAA2022041883699Panel · elongatedPANEL 621VB HAS ELONGATED HOLE - RED DOT / [01] PREPARED AREA FOR REPAIR ENLONGATED HOLES AT PANEL #621 VB AS PER B737-700 SRM 51-70-04-2R-9;[02] VERIFIED STEP #1.;[03] REPAIRED HELONGATED HOLE AT PANEL #621 VB AS PER B737 -700 SRM 51-70-04-2R-9;[04] VERIFIED SDR SWAA2022031182121Floor Panel · crackedFORWARD CARGO COMPARTMENT BIN C FLOOR PANEL CRACKED. / [01] REMOVED FWD CARGO FLOOR PANEL 120CF.;[02] R&R FWD CARGO COMPARTMENT PANEL 120CF REF AMM 25-52-10. THIS COMPLETES MEL 25-16-01.SDR SWAA2022030379871Pump · lowENGINE 1 A HYDRAULIC SYSTEM PUMP LOW PRESSURE LIGHT ILLUMINATED ON CLIMB OUT REF LOG PAGE 2018628 IN CLIMB OUT ENG 1 A HYDRAULIC SYSTEM PUMP LOW PRESSURE LIGHT ILLUMINATED SOON AFTER A SYSTEM QUANTITY BEGAN TO DECREASE / [01] R/R A SYSTEM ENGINE DRIVEN PUMP PESDR SWAA2022030379876Pump · lowENGINE 1 A HYDRAULIC SYSTEM PUMP LOW PRESSURE LIGHT ILLUMINATED ON CLIMB OUT REF LOG PAGE 2018628 IN CLIMB OUT ENG 1 A HYDRAULIC SYSTEM PUMP LOW PRESSURE LIGHT ILLUMINATED SOON AFTER A SYSTEM QUANTITY BEGAN TO DECREASE / [01] R/R A SYSTEM ENGINE DRIVEN PUMP PESDR SWAA2022011861483Light · inoperativeCAPT SIDE.. SIDEWALL LT @ UPPER OVER WING EMERGENCY INOP ; / [01] OK TO CONTINUE PER MEL # 33-2-03 SP#!B; [02] RELAMPED SIDEWALL (WINDOW) LIGHT IAW AMM 33-21-00.OPS TEST. GOODSDR SWAA2022011861484Lens · missingEMERGENCY LT COVER MISSING @ OVERWING LOWER F/OS SIDE EMERGENCY EXIT ; / [01] REMOVED AND REPLACED THE EMERGENCY LENS COVER IAW AMM 33-51-21 OPS CHECK NORMAL.SDR SWAA2022010658782Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1668; M1669; M1672; M1673; M1674; 1M1670; M1675. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT LOCATIONS M1668; M1669; M1672; M1673; M1674; 1M1670; M1675 PER AMM 33-51-06 WITH REFERENCE TO DRAWISDR SWAA2022010658752Floorbeam · crackedFLOOR BOARD INTERCOSTAL IS CRACKED AT STA 540 LBL 0-24 AND RBL 0-24. REMOVED AND REPLACED INTERCOSTAL PER AMM 20-50-11 AND SRM 51-40-02.SDR SWAA2021113047943None · failedFWD RIGHT GALLEY DOOR GIRT BAR HUNG UP ON DOOR FRAME ; / [01] REINSTALLED R2 DOOR SLIDE PER AMM 25-66-01-400-804.SDR SWAA2021012644440Hook And Loop · looseSLIDE DEPLOYMENT TAB LOOSE. RESECURED VELCRO AS REQUIRED. PERFORMED ESCAPE SLIDE PACK CHECK, IAW TASK 25-66-01. A/C OK FOR SERVICE.SDR SWAA2020061892462Handle · brokenFWD ENTRY DOOR LOWER ASSIST HANDLE BROKEN. (P/N 65-5458-20E) / REMOVED AND REPLACED FWD ENTRY DOOR LOWER ASSIST HANDLE PER AMM 52-11-31SDR SWAA2020031942573Rib · crackedRIGHT HAND HORIZONTAL STAB #4 INSPAR RIB (STAB STA 120.3) IS CRACKED AT #2 STIFFENER. / RIB CRACKED REPAIRED PER SRM 55-10-09-2R-REPAIR 4. REF. WIP ENTRY DOR INDIVIDUAL SIGNED OFF.SDR SWAA2020031942571Rib · crackedRIGHT HAND HORIZONTAL STAB #4 INSPAR RIB (STAB STA 120.3) IS CRACKED AT #4 STIFFENER. / RIB CRACKED REPAIRED PER SRM 55-10-09-2R-REPAIR 4. REF. WIP ENTRY DOR INDIVIDUAL SIGNED OFF.SDR SWAA2020033033913Floor Panel · dentedFLOORBOARD PANEL 241LF HAS DENTS. / RECEIVED FLOORBOARD PANEL 241LF FROM STOCK. R & R TO BE COMPLETED ON NRC G722267.SDR SWAA2020033033914Floor Panel · dentedFLOORBOARD PANEL 241UF HAS DENTS. / RECEIVED FLOORBOARD PANEL 241UF FROM STOCK. R & R TO BE COMPLETED ON NRC G722267.SDR SWAA2020033033915Floor Panel · dentedFLOORBOARD PANEL 241VF HAS DENTS. / RECEIVED FLOORBOARD PANEL 241VF FROM STOCK. R & R TO BE COMPLETED ON NRC G722267.SDR SWAA2020031942572Access Panel · deformedCOCKPIT FLOOR ACCESS PANEL 211AF IS DEFORMED. / INSTALLED NEW PANEL AS PER SOPM 20-50-01 AND EA-1-753-36714SDR SWAA2020033033895Web · cutCOCKPIT FLOOR; LOWER FLOOR WEB CUT AT STA 255 AT RBL -5 APPROX. 2.0 INCHES / COCK PIT FLOOR REPAIRED PER EA/1-753-36714SDR SWAA2020033033883Seat Track · wornSEAT TRACK #4 STA 360 TO 480 REQUIRES REPLACEMENT DUE TO WORN OUT OF LIMITS / REMOVED AND REPLACED #4 SEAT TRACK STA 366 TO 480 PER SRM 51-40-02.SDR SWAA2020033033884Seat Track · wornSEAT TRACK #4 STA 520 WILL BE REPAIRED PER SRM DUE TO WEAR / SEE NON ROUTINE CARD G721454 FOR WORK DONE ON SEAT TRACK REPAIR PER SRM 53-00-52-2R-4.SDR SWAA2020033033861Floor Panel · dentedPASSENGER CABIN FLOORBOARD 242AF HAS DENTS. / REMOVED AND REPLACED IAW AMM 53-21-00.SDR SWAA2020033033862Floor Panel · dentedPASSENGER CABIN FLOORBOARD 242BF HAS DENTS. / REMOVED AND REPLACED IAW AMM 53-21-00.SDR SWAA2020033033860Floor Panel · dentedPASSENGER CABIN FLOORBOARD 241BF HAS DENTS. / REMOVED AND REPLACED IAW AMM 53-21-00.SDR SWAA2021081733817Bracket · crackedBRACKET IS CRACKED ON RIGHT WING UPPER SHELF PANEL INBOARD OF DEFLECTOR RIB. / REMOVED AND REPLACED BRACKET PER SRM 51-40-02.SDR SWAA2020033033853Rib · crackedLEFT HORIZONTAL #4 INSPAR RIB #3 (STAB. STA.120.3) IS CRACKED 1' FROM BOTTOM EDGE. / INSTALLED REPAIR PARTS PER SRM 55-10-09-2R-4. SEE INDIVIDUAL SIGN-OFFS FOR WORK PERFORMED.SDR SWAA2020033033833Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 387 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.
Back to N246LV