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 SWAA2024031453734Bracket · crackedCRACK SUPPORT BRACKET BS 540 AND RBL 6 RT AT AIR CONDITIONING BAY 2024-123406<[01] REPLACED SUPPORT BRACKET BS 540 AND RBL 6 RT AT AIR CONDITIONING BAY IAW B737-700 SRM 51-40-02-0G-0.;[02] COMPLETED JOBSDR SWAA2024031453727Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED IRSS 140 RT WING 2024-123400<[01] REPLACED ANGLE TRAILING EDGE LOCATED IRSS 140 RT WING IAW B737-700 SRM 51-10-02 ITEM 9;[02] REPLACED ANGLE TRAILING EDGE LOCATED IRSS 140 RT WING IAW B737-700 SRM 51-10-02 ITEM 9<BR>SEE INDIVISDR SWAA2024031453731Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED IRSS 140 AT LT WING 2024-123407<[01] REPLACED ANGLE TRAILING EDGE LOCATED IRSS 140 AT LT WING IAW B737-800 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG: 115A2000 SHEET: 21 REV: -;[02] CORRECTIVE STEP 1<BR><BR>REPLACED ANGLE TRSDR SWAA2024031453732Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA AT LT WING 2024-123409<[01] REPLACED ANGLE TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA AT LT WING IAW B737-700 SRM 51-40-02-0G AND DWG 115A2930; SHEET 7; REV -.;[02] CORRECTESDR SWAA2024031453735Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 283 DEFLECTION CONTROL RIB AREA AT LT WING 2024-123411<[01] REPLACED ANGLE TRAILING EDGE LOCATED ORSS 283 DEFLECTION CONTROL RIB AREA AT LT WING IAW B737-700 SRM 51-40-02 AND DRAWING # 115A6200 REV ?B? THE MEASURE OF CRACSDR SWAA2024031453728Bracket · crackedCRACK SUPPORT BRACKET TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA RT WING 2024-123403<[01] REPLACED SUPPORT BRACKET TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA RT WING IAW B737-700 SRM 51-40-02.TOOL USED CALIPER P/N:500-196-30;S/NSDR SWAA2024031453726Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA RT WING 2024-123401<[01] REPLACED ANGLE TRAILING EDGE LOCATED ORSS 273 DEFLECTION CONTROL RIB AREA RT WING IAW B737-700 SRM 51-40-02 MEASURE CRACK IS:L=0.330?.TOOL USED CALIPER P/N:500-196-SDR SWAA2024031453830Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 927 TO BS 947.5 AT LEVEL STR 25R AT AFT CARGO COMPARTMENT 2024-123423<[01] REPLACED WEB INTERCOSTAL AND FASTENERS LOCATED BTW BS 927 TO BS 947.5 AT LEVEL STR 25R AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-1SDR SWAA2024031353584Drip Tray · crackedCRACK ON DRIP SHIELD OF RACK WEATHER RADAR MOUNT IN FWD ACCESSORY COMPARTMENT 2024-123398<[01] REMOVED AND REPLACED DRIP SHIELD OF RACK WEATHER RADAR MOUNT IN FWD ACCESSORY COMPARTMENT IAW B737-700 SRM 51-40-02;[02] CORRECTED STEP 1<BR>REMOVED AND REPLACED DRISDR SWAA2024031253736Cargo Track · crackedCRACK TRACK RBBL 13.84 LOCATED BS 727E AT AFT CARGO COMPARTMENT 2024-123415<[01] TOOL USED EDDY CURRENT EQUIPMENT P/N NORTEC 600D; S/N 200048001 DUE DATE 01-MAY-24 USED ON STEP 6;[02] REPAIRED TRACK RBBL 13.84 LOCATED BETWEEN BS 727D TO BS 727E AT AFT CARGO COSDR SWAA2024031253826Cargo Track · crackedCRACK TRACK RBBL 13.84 LOCATED BS727C AT AFT CARGO COMPARTMENT 2024-123416<[01] TOOL USED EDDY CURRENT EQUIPMENT P/N NORTEC 600D; S/N 200048001 DUE DATE 01-MAY-24 USED ON STEP 5;[02] REPAIRED TRACK RBBL 13.84 LOCATED BETWEEN BS727B TO BS727D AT AFT CARGO COMPASDR SWAA2024031453585Access Panel · crackedCRACK LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 95.96 AT LT HORIZONTAL STABILIZER 2024-123393<[01] REPLACED LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 95.96 AT LT HORIZONTAL STABILIZER IAW B737-700 SRM 51-10-02 Ï¿½TEM 9 SRM 51-40-02 AND DWG 186ASDR SWAA2024031453586Access Panel · crackedCRACK LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 105.26 AT LT HORIZONTAL STABILIZER 2024-123394<[01] REPLACED LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 105.26 AT LT HORIZONTAL STABILIZER IAW B737-700 SRM 51-10-02 Ï¿½TEM 9 SRM 51-40-02 AND DWG 18SDR SWAA2024031453527Angle · crackedCRACK ANGLE FRONT SPAR LOCATED BS 1016 AT VERTICAL STABILIZER 2024-123384<[01] REPLACED ANGLE AND FASTENERS LOCATED FRONT SPAR BSTA 1016 AT VERTICAL STABILIZER IAW B737-700 SRM 51-40-02. SRM 51-10-02 PARAGRAPH 9. AND DWG# 173A3001. SHEET 23. REV. ?D?. SEE INDISDR SWAA2024031452976Angle · crackedCRACK ON ANGLE LOCATED SLAT 8 AUXILIARY TRACK INBOARD SIDE AT RT WING 2024-123335<[01] REMOVED AND REPLACED ANGLE LOCATED ON AUXILIARY TRACK 8 INBOARD SIDE AT RT WING IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND PERFORMED INBOARD AUXILIARY TRACK SKIN SDR SWAA2024031353108Angle · crackedCRACK ANGLE - CLIP LOCATED BS440 AND STR26L FWD CARGO COMPARTMENT 2024-123350<[01] REPLACED ANGLE - CLIP LOCATED BS440 AND STR26L FWD CARGO COMPARTMENT; WEB-INTERCOSTAL AND FASTENER LOCATED BETWEEN STA440 TO STA 460 IAW B737-700 SRM 51-10-02-0G-0 AND DWG 143A7SDR SWAA2024031353109Angle · crackedCRACK ANGLE - CLIP LOCATED BS500C AND STR26L FWD CARGO COMPARTMENT 2024-123351<[01] INSTALLED ANGLE - CLIP LOCATED BS500C AND STR26L FWD CARGO COMPARTMENT; WEB-INTERCOSTAL AND FASTENER LOCATED BETWEEN STA 500C TO STA 500D IAW B737-700 SRM 51-10-02-0G-0 AND DWGSDR SWAA2024031352423Floor Panel · deterioratedDETERIORATED SLEEVE FLOOR PANEL 241ABF AT AFT GALLEY AND LAV (5 EA) 2024-123230<[01] REPLACED SLEEVE FLOOR PANEL 241ABF AT AFT GALLEY AND LAV (5 EA) B737-700 SRM 53-00-50-2R-0 REPAIR GENERAL PARAGRAPH 5.B(2) S (1). TOOL USED: SCALE: P/N: CL5000 S/N: AE-39087 DSDR SWAA2024031451930Floorbeam · corrodedCORROSION FLOOR BEAM LOCATED STA 986.5 AND LBL44 WL208.1 AT AFT GALLEY AREA 2024-123206<[01] TOOL USED ON STEP 4 IS THICKNESS GAGE PN: 45MG; SN: 221860711; DUE DATE: 21-NOV-24;[02] REPAIRED FLOOR BEAM LOCATED STA 986.5 AND LBL44 WL208.1 AT AFT GALLEY AREA IAW SDR SWAA2024031352107Frame · crackedCRACK FRAME ON BS 312 BETWEEN STR 5L TO STR 6L FWD GALLEY AND LAV 2024-123220<[01] PERFORMED REPAIR ON FRAME IAW EA M-22-153-0124.;[02] CORRECTED STEP 1.<BR>PERFORMED REPAIR ON FRAME IAW EA M-22-153-0144. ?SEE INDIVIDUAL SIGNOFFS BELOW?.;[03] CORRECTED STEP 2.SDR SWAA2024031352109Stub Frame · crackedCRACK STUB FRAME UPPER POSITION LOCATED STA294.5 AND STR 8R TO STR 9R AT PASSENGER CABIN 2024-123226<[01] REPLACED STUB FRAME LOCATED ON BS 294.5 & STRINGER 8R TO 9R AT PASSENGER CABIN. IAW B737-700 SRM 51-10-02 & DWG # 141A8370 SHEET 9 & REV D.;[02] CORRECTEDSDR SWAA2024031352108Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BETWEEN STA294.5 TO STA303.9 AND STR16L AT FWD GALLEY AREA 2024-123223<[01] REPLACED WEB-INTERCOSTAL AND FASTENERS LOCATED BETWEEN STA 294.5 TO STA 303.9 AND STRINGER 16L AT FWD GALLEY AREA; IAW BOEING 737-700 SRM 51-40-02; BOEINGSDR SWAA2024031352106Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 500 TO BS 520 AT LEVEL STR 26L FWD CARGO COMPARTMENT 2024-123221 CRACK WEB - INTERCOSTAL LOCATED BTW BS 500 TO BS 500A AT LEVEL STR 26L FWD CARGO COMPARTMENT<[01] REPLACED WEB - INTERCOSTAL LOCATED BTW BS 500 TO BS 500A ASDR SWAA2024031451728Web · corrodedCORROSION WEB LOCATED BS294.5 TO BS 312 AND LBL 12 WL 208..1 AT FWD GALLEY AREA 2024-123172<[01] REPLACED WEB INTERCOSTAL AND FASTENERS LOCATED BS 294.5 TO BS 312 AND LBL 12 WL 208.1 AT FWD GALLEY AREA I.A.W B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG 141A5600SDR SWAA2024031351725Stringer · crackedCRACK INNER CHORD LOCATED BS303.9 AND S-17L AT FWD GALLEY AREA 2024-123168<[01] REPLACED INNER CHORD BS 277 TO BS 268.25 AND STRINGER 17L AT FWD GALLEY AREA; IAW BOEING 737-700 SRM 51-10-02 Ï¿½TEM 9; BOEING 737-700 SRM 51-40-02 AND BOEING 737-700 DRAWING 141A8SDR SWAA2024031351724Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS277 TO BS294.5 AND BL 0 FWD GALLEY AND LAV 2024-123167<[01] REPLACED WEB INTERCOSTAL FLOOR STRUCTURE LOCATED BS277 TO BS294.5 AND BL 0 FWD GALLEY IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9; DWG 141A5400 SDR SWAA2024031351727Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 312 TO BS328 AND RBL 30 FWD GALLEY AND LAV 2024-123171<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 312 TO BS328 AND RBL 30 FWD GALLEY AND LAV IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 DWSDR SWAA2024031351726Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV 2024-123170<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BTW BS 312 TO BS 328 AND LBL 46 FWD GALLEY AND LAV. IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-0SDR SWAA2024031251731Floorbeam · corrodedCORROSION FLOOR BEAM LOCATED STA 986.5 AND RBL44 WL208.1 AT AFT GALLEY AREA 2024-123181<[01] TOOL USED ON STEP 4: ULTRASONIC THICKNESS GAUGE; PN: 45MG; SN: 130066701 ; DUE DATE: 09-JUN-24;[02] TOOL USED STEP 11; 12 AND 13: EDDY CURRENT EQUIPMENT; P/N: NORTEC 5SDR SWAA2024031251732Floorbeam · corrodedCORROSION FLOOR BEAM LOCATED STA 986.5 AND RBL40.5 WL208.1 AT AFT GALLEY AREA 2024-123182<[01] TOOL USED ON STEP 4: ULTRASONIC THICKNESS GAUGE; PN: 45MG; SN: 130066701 ; DUE DATE: 09-JUN-24;[02] PERFORMED REPAIR ON FLOOR BEAM LOCATED STA 986.5 AND RBL 18 TO RBSDR SWAA2024031251334Light · inoperativeINOP EMERGENCY LIGHT ASSY ON SIDEWALL PANELS 232YHW AT PASSENGER CABIN 2024-123157<[01] REPLACED EMERGENCY LIGHT ASSY ON SIDEWALL PANELS 232YHW AT PASSENGER CABIN I.A.W. SOPM 20-50-01 REV 38 AND B737-700 AMM 33-51-00-710-801 TEST IS OK;[02] REPLACED EMERGENCY SDR SWAA2024031251146Fitting · deterioratedDETERIORATED GIRT BAR FITTING HARDWARE ENTRY AND SERVICE DOOR AT FWD GALLEY AREA 2024-123041<[01] REPLACED GIRT BAR FITTING HARDWARE ENTRY AND SERVICE DOOR AT FWD GALLEY AREA IAW BOEING SOPM 20-50-01 REV. 38 AND INSTALLATION WILL BE DOCUMENTED ON MT TTG8Q003BGSDR SWAA2024031251145Fitting · deterioratedDETERIORATED GIRT BAR FITTING HARDWARE ENTRY AND SERVICE DOOR AT AFT GALLEY AREA 2024-123040<[01] REPLACED GIRT BAR FITTING HARDWARE ENTRY AND SERVICE DOOR AT AFT GALLEY AREA IAW B737-700-AMM 25-66-02-400-801 AND THE INSTALLATION IS DOCUMENTED IN JOB CAR 725-0SDR SWAA2024031450878Skin · crackedCRACK LEADING EDGE LOCATED ON SLAT STATION 322.71 AT LT WING 2024-123002<[01] TOOL USED IN STEP 4: EDDY CURRENT INSTRUMENT P/N: NORTEC 600D; S/N: 210138503; DUE DATE: 21-JUL-24;[02] TOOL USED: EDDY CURRENT INSTRUMENT P/N: NORTEC 600D; S/N: 200053402; DUE DATE:SDR SWAA2024031450877Skin · crackedCRACK LEADING EDGE LOCATED ON SLAT STATION 451.97 AT RT WING 2024-123001<[01] TOOL USED EDDY CURRENT EQUIPMENT P/N NORTEC 600D; S/N 200048001 DUE DATE 01-MAY-24 USED ON STEP 4;[02] TOOL USED: EDDY CURRENT INSTRUMENT P/N: NORTEC 600D; S/N: 200053402; DUE DATE: SDR SWAA2023112022037Floorboard · splitAFT CARGO - COMPOSITE FLOORBOARD FWD OF SHEETMETAL FLOORBOARD SPLIT<[01] REMOVED AND REPLACED FLOOR BOARD PER AMM 25-52-10SDR SWAA2023083095257Battery Pack · inoperativeEMERGENCY LIGHT BATTER BACK LEFT AFT BREAKER POPPED<[01] REMOVED AND REPLACED L/H AFT EMERGENCY LIGHT POWER SUPPLY PER AMM 33-51-06 OPS CHECK GOODSDR SWAA2023070572223Support Frame · crackedWING TO BODY SUPPORT FRAME P/N 149A7177-1 AT STATION 540 FWD FLANGE IS CRACKED AT LBL 14<[01] CUT OUT DAMAGE ON FWD FLANGE OF WING TO BODY SUPPORT FRAME AT STA 540 LBL 14;[02] VERIFIED CRACK FREE AFTER CUT OUT IAW B737 NDT P6 51-00-00 P23 TOOL 44291 DUE 03NOV2SDR SWAA2023062772067Light · inoperativeLEFT OVERWING EXIT LIGHT IS INOP EXTERNAL LEFT OVERWING EXIT LIGHT. ACCOMPLISHED EMERGENCY LIGHT BATTERY PACK TEST IAW AMM 33-51-06-200-801. TESTS GOOD.SDR SWAA2023070570163Web · crackedDOT A24-07 LH A/C BAY. METAL WEB COMMON TO VAPOR BARRIER AND PACK EXHAUST SEAL CRACKED JUST I/B OF EXHAUST SEAL.<[01] AUDIT C/WSDR SWAA2023062160112Attach Angle · crackedBS 663 RBL 31 VERTICAL PRESSURE WEB LOWER ATTACH ANGLE O/B NUTPLATE HOLE HAS A CRACK INDICATION. REMOVED DAMAGE IAW SRM 57-10-10-2R-6 FIG 202 & SRM 51-40-02. ACCOMPLISHED HFEC IAW NDT PART 6 51-00-00 PROCEDURE 23. NO DEFECTS NOTED. PERFORMED INSURANCE CUT SDR SWAA2023062160111Attach Angle · crackedBS 663 LBL 34 VERTICAL PRESSURE WEB LOWER ATTACH ANGLE HAS ONE CRACK INDICATION AT DRAIN HOLE I/B NUTPLATE HOLE. CUT & REMOVED DAMAGED SECTION OF ATTACH ANGLE AT I/B NUTPLATE IAW SRM 57-10-10-2R-6 SECTION 4. C. ACCOMPLISHED HFEC IAW NDT PART 6 51-00-00 PROCESDR SWAA2023062158476Bulkhead Web · crackedLEFT HAND STA 663 VAPOR BARRIER WEB IS CRACKED AT LBL 43<[01] VERIFIED NEW WEB RECIEVED ON SHOP W/O 44927/1000/0002 PER DWG 111A1141;[02] VERIFIED STEP 1;[03] FABRICATED NEW LH STA 663 VAPOR BARRIER WEB IAW BOEING DWG 111A1141 REV- AND SRM 51-40-05-0G-0;[04] VSDR SWAA2023062158480Attach Angle · crackedCRACK FOUND ON LOWER ATTACH ANGLE STA 663 LBL 45 (WL193)<[01] CUT LOWER ATTACH ANGLE AS SHOWN IN FIG 2. IAW EA 23-157-01890-WIP1. CUT LOWER ATTACH ANGLE AS SHOWN IN FIG 2. IAW EA 23-157-01890-WIP1. REFER TO FAULT TTG8Q00LLRTH WHERE EA 23-157-01890 WAS ADDED ASDR SWAA2023062158475Attach Angle · crackedCRACK FOUND ON LOWER ATTACH ANGLE STA 663 RBL 45, WL193. REMOVED THE REPAIR THAT WAS ORIGINALLY INSTALLED PER NRC T762520. INSTALLED A NEW REPAIR PER EA 23-157-01894 [SRM 57-10-10-2R-3 (REPAIR 3 ALTERNATE 2) AND SRM 57-10-10-2R-6 (REPAIR 6)]. INSPECTION THRESSDR SWAA2023062158474Attach Angle · crackedCRACK FOUND ON UPPER ATTACH ANGLE AT STA 663 RBL 39 (WL167)<[01] OK TO INSTALL REPAIR ANGLE AND SPLICE. ANGLE REQUIRES CIC;[03] OK TO CIC;[04] CICED REPAIR ANGLE I.A.W MM 51-21-91-620-802.SDR SWAA2023062058466Handle · looseL-1 DOOR; LOWER AFT DOOR LINER AND SIDE WALL DOOR SURROUND ASSIST HANDLES ARE LOOSE.<[01] SECURED L1 DOOR; LOWER AFT DOOR LINER AND AFT SURROUND PANEL ASSIST HANDLES IAW AMM 52-11-31-400-802 STEP 3G(2);[02] VERIFIED STEP 1.<BR>AUDIT C/W.SDR SWAA2023062158464Fairing · elongatedDOT A24-2 #1 FLAP TRACK AFT FAIRING ASSY. AFT SEAL RETAINER HOLE ELONGATED IN COMPOSITE FAIRING SKIN.<[01] EVALUATED AND FOUND AFT SEAL RETAINING O/B HOLE ELONGATED IN SOLID LAMINANTE AS MARKED. FOUND TO BE REPAIRABLE IAW SRM 57-53-70-2R-1 STEP 2(B)(2) AND SRMSDR SWAA2023062058294Light · inoperativeREMOVE / INSTALL PHOTOLUMINSCENT STRIPS FROM CENTER WING BOX AREA<[01] REMOVED PHOTOLUMINESCENT STRIPS FROM CENTER WING BOX AREA IAW AMM-33-51-15-000-802. INSTALLED PHOTOLUMINSCENT STRIPS IN CENTER WING BOX AREA IAW AMM 33-51-15-000-802.SDR SWAA2023060154936Smoke Detector · activatedFIRE ALARM FWD LAV<[01] R&R FWD LAV SMOKE DETECTOR IAW AMM 26-14-01. OPS OK AT THIS TIME.
Back to N246LV