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 SWAA2020033033856Seat Track · gougedCABIN SEAT TRACK NO.1 HAS GOUGE BS520. (MARKED) / REPAIRED SEAT TRACK PER SRM 53-00-52-2R-4.SDR SWAA2020033033836Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 425 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2020033033843Seat Track · wornCABIN SEAT TRACK NO.4 HAS WEAR FROM STA500A-520. (MARKED) / REMOVED AND REPLACED CABIN SEAT TRACK NO.4 FROM STA 500C+10 TO STA 520 IAW SRM 53-00-52-2R-4 AND EA 1-A53-11779. SEE WIPS AND TASKS FOR INDIVIDUAL SING OFFS OF WORK PERFORMED.SDR SWAA2020033033832Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 413 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2020033033855Rib · crackedRIGHT HORIZONTAL #4 INSPAR RIB #3 (STAB. STA.120.3) IS CRACKED 1' FROM BOTTOM EDGE. / RIB CRACKED REPAIRED PER SRM 55-10-09-2R-4 REPAIR 4 (SEE WIP #6) AND RIB REINSTALLED PER SRM 51-40-02 (ON SUBTASK #4)SDR SWAA2020031342416Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 451 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2020031342415Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 413 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2020031342414Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 425 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2020031342413Seat Track · corrodedSEAT TRACK #4 CORROSION AT B.S. 387 (MARKED) / TO BE REPLACED ON NRC G721942 WHICH COVERS #4 TRACK FROM BS 360-480.SDR SWAA2021082303814Mount · broken#2 ENGINE AFT STRUT FAIRING AFT FAIRING SECTION HAS BROKEN MOUNT CASTING. / REMOVED AND REPLACED AFT FAIRING CAST ASSEMBLY PER SRM 51-40-02.SDR SWAA2020032442639Floor Panel · dentedCOCKPIT FLOOR DENTED UNDER AND ADJACENT TO SECOND OBSERVERS SEAT. / COCKPIT FLOOR REPAIRED PER EA 1-753-36714SDR SWAA2021081306500Pan · crackedAFT SERVICE DOOR LOWER LINER FORWARD PAN ANGLE CRACKED. / REPLACED PAN PER MM 52-41-31SDR SWAA2019121639694Sign · incorrectL2 DOOR EXIT SIGN LENS COVER HAD ARROW POINTING IN WRONG DIRECTION. / R&R EXIT SIGN ASSEMBLY IAW AMM.SDR SWAA2019101437715Slide · dislodgedFORWARD ENTRY DOOR SLIDE FELL OUT OF COMPARTMENT, DID NOT DEPLOY, STILL OPERATIONAL. R&R FORWARD ENTRY DOOR SLIDE PER MT.SDR SWAA2019062734194Lanyard · out of positionR/H SIDE EMERGENCY EXIT DOOR CLOSING ASSIST TETHER WILL NOT STAY IN PLACE ON OVERWING EXIT. / INSTALLED HARDWARE PER AMM.SDR SWAA2019011628486Girt Bar · out of positionR1 DOOR SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED GIRT BAR PER MT.SDR SWAA2018111526776Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2022022320831Floor Panel · corroded***CORROSION*** FWD CARGO BAY FLOOR PNL 120BF HAS CORROSION AROUND EDGES / FABRICATED NEW FCB FLOOR PANEL 120BF FROM .080 2024T3; LOT # 1360028-1 PER AMM 25-52-01-201-801 AND DWG 453A1610SDR SWAA2018053022333Fitting · looseR1 DOOR SLIDE BAR LOOSE. SECURED CLIP PER SIP.SDR SWAA2018042421358Girt Bar · looseRI DOOR SLIDE GIRT BAR LOOSE. SECURED THE GIRT BAR IAW MM.SDR SWAA2022021114910Floor Panel · brokenPASSENGER CABIN FLOOR PANEL 221BF 'EAR' IS BROKEN / EVALUATED; PREPPED; CLEANED AND REPAIRED DAMAGE TO UPPER AND LOWER FACESHEETS INCLUDING CORE AREA ON FLOORBOARD 221BF IAW B737 SRM 53-00-50-2R-6; PAR 3(A-K1; L1-M1) REV 64.SDR SWAA2018032920859Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHTS AFT DOOR HAD A BULB INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2018032920855Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHTS FORWARD DOOR THE BULB WAS FOUND INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2018032920854Frame · crackedR1 DOOR AFT FRAME WAS FOUND CRACKED. R & R THE DOOR IAW AMM.SDR SWAA2018032720697Connector · brokenLEFT OVERHEAD BIN EMERGENCY EXIT LIGHT HARNESS WIRE BROKEN AT CONNECTOR, ROW 4. REPAIRED THE CONNECTOR IAW WDM & AMM.SDR SWAA2022021014898Support · crackedWEATHER RADAR RECEIVER/ TRANSMITTER TRAY MOUNT; RH SUPPORT STRUCTURE IS CRACKED / WEATHER RADAR RECEIVER/TRANSMITTER TRAY MOUNT CRACK IS REPAIRED SEE SA-M 326 A1208214 FOR REPAIR AND INSTALLATION OF WEATHER RADAR RT & MOUNT AND WEATHER RADAR OPERATIONAL CHECK.SDR SWAA2022020914893Angle · corroded***CORROSION*** ACB FWD MAIN SILL; STA 767-787; RBL 21; INTERCOSTAL HAS CORROSION ON UPR SHIELD ATTACH ANGLE LWR SURFACE NUTPLATE AREAS / WEB ATTACH ANGLE BS 767-787; RBL 21 CORROSION FOUND TO BE OUT OF LIMITS DUE TO CORROSION AROUND FASTENER HOLES PER SRM 53-SDR SWAA2018032820829Nut Plate · corrodedAFT CARGO BAY FORWARD MAIN FLOOR SUPPORT NUT PLATE CORRODED BETWEEN BS 787 TO 792, RBL 20. R & R THE NUT PLATE IAW SRM AND DWG.SDR SWAA2018032720696Floor Support · corrodedAFT CARGO BAY FORWARD MAIN FLOOR SUPPORT CORRODED BETWEEN BS 787 TO 792, RBL 20. R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2018032720687Floor Support · corrodedAFT CARGO BAY FORWARD MAIN FLOOR SUPPORT CORRODED BETWEEN BS 767 TO 787, RBL 20. R & R THE FLOOR SUPPORT IAW DWG AND SRM.SDR SWAA2022021114888Nut Plate · crackedFWD CARGO BAY FWD DOOR FRAME BS440; RBL24 NUT PLATE STRIP CRACKED. / REMOVED AND INSTALLED NEW FCD FRAME NUTPLATE CARRIER BS 440; RBL 24 FABRICATED FROM 7075T6 # 0.032' CLAD LOT# 1293003 PER DWG 143A8200; SENT TO OSS ANODIZE ON P.O.# 677904-SWA; PRIMED; SEALEDSDR SWAA2018032720685Shield · corrodedAFT CARGO BAY CORRODED ON SHIELD CORRODED BETWEEN BS 767 TO 794, RBL 21. R & R THE SHIELD IAW DWG AND SRM.SDR SWAA2018032820828Support Angle · crackedFORWARD CARGO BAY FORWARD, LOWER ANGLE TO FLOOR SUPPORT CRACKED AT BS 400, LBL 26. R & R THE SUPPORT ANGLE SRM & DWG.SDR SWAA2022021114833Door · corroded***CORROSION*** LAV SERVICE DOOR HINGES ARE CORRODED / REMOVED AND REPLACED LAV SERVICE DOOR ASSY PER AIPC 52-49-07-01 & SOPM - 20-50-01; BONDING CHECK IS GOOD PER SWPM 20-20-00. FUNTION DOOR IS GOOD. 43046U 17MAR18 56090C 17MAR18SDR SWAA2022021114827Floor Panel · delaminatedFLOORPANEL 241AAF DELAMINATED / DUE TO THE EXTENT OF DELAMINATION DAMAGE; FABRICATED NEW FLOOR PANEL 241AAF IAW SRM 53-00-50-2R-0 PARA 1A (NOTE AND DWG 147A5810-8. 57066U 3/13/18SDR SWAA2022021114829Floor Panel · delaminatedFLOORPANEL 242 UF DELAMINATED / REPLACED FLOOR PANEL 242UF DUE TO MULTIPLE AREAS OF DELAMINATION ON UPPER SURFACE SKIN IAW SRM 51-10-02-0G-0 PAR 9 AND AIPC 53-21-00-26 ITEM 116SDR SWAA2022021114834Seal · crackedLT HORIZ. STAB FWD UPPER SLIDE SEAL IS CRACKED. / REMOVED AND REPLACED L/H HORIZONTAL STAB FWD UPPER CRACKED SLIDE SEAL IAW AMM 53-31-31-000-802 PAR. 2B AND 53-31-31-400-802 PAR. 3 C AND D. 57048U 09MAR18SDR SWAA2022021114828Floor Panel · delaminatedFLOORPANEL 241ACF DELAMINATED / REPAIRED DELAMINATION ON FLOORPANEL 241ACF IAW SRM 53-00-50-2R-1. 57066U 3/12/18SDR SWAA2018032820827Floor Support · corrodedAFT CARGO BAY ON FLOOR SUPPORT CORRODED AT BS 906, LBL 8. REPAIRED THE FLOOR SUPPORT IAW ER & EA.SDR SWAA2018032720723Support · corrodedAFT CARGO BAY SUPPORT CORRODED AT BS 882, RBL 22. R & R THE SUPPORT IAW SRM & DWG.SDR SWAA2018032720695Cargo Track · corrodedAFT CARGO TRACK CORRODED BETWEEN BS 779 TO 887, RBL 13.84. R & R THE CARGO TRACK IAW SRM.SDR SWAA2018032720694Support · corrodedAFT CARGO BAY LEFT FLOOR TO SIDE WALL SUPPORT CORRODED BETWEEN BS 727 TO 847. R & R THE SUPPORT IAW SRM AND DWG.SDR SWAA2018032720693Support Angle · corrodedR1 DOOR MOPSILL THRESHOLD SUPPORT ANGLE CORRODED BETWEEN BS 312 TO 328, RBL 57. R & R THE SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2018032720684Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED AT BS 924.5, RBL 22. R & R THE SUPPORT IAW SRM AND DWG.SDR SWAA2018032720683Sidewall Support · corrodedAFT CARGO BAY RT FLOOR TO SIDE WALL SUPPORT CORRODED BETWEEN BS 727 TO 767. R & R THE SIDEWALL SUPPORT IAW SRM AND DWG.SDR SWAA2018032020545Door Sill · corrodedR2 DOOR MOPSILL CORRODED BETWEEN BS 967 TO BS 986, RBL 51. R&R MOPSILL IAW SRM AND DWG.SDR SWAA2018031920464Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED AT BS 856, RBL 22. R & R THE SIDEWALL SUPPORT IAW SRM AND DWG.SDR SWAA2018031920463Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 294 TO 312, RBL 16. R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2018031520442Floor Support · crackedFLOOR SUPPORT UPPER ATTACH ANGLE CRACKED BETWEEN BS 380 TO 400, RBL 12. R & R THE FLOOR SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2018031520441Floor Support · crackedFLOOR SUPPORT UPPER ATTACH ANGLE CRACKED BETWEEN BS 380 TO 400, LBL 15. R & R THE FLOOR SUPPORT IAW SRM AND DWG.
Back to N246LV