N440LV
Service difficulty reports · 304
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 = 'N440LV' 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 = 'N440LV' 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 SWAA2023070563506Fitting · corrodedVERTICAL FIN FRONT SPAR FITTING AT STA 1016 L/H BOLT HAS A SPOT OF CORROSION.<[01] REMOVED AND REPLACED VERTICAL FINFRONT SPAR FITTINGAT STA 1016 L/H BOLT AS PER AMM 55-30-200-801 TORQUE WRENCH <BR> BC 175291 <BR> DUE DATE: 11/18/23;[02] REMOVED AND REPLACED VSDR SWAA2023070563504Sign · crackedLAVATORY B EMERGENCY EXIT SIGN CRACKED<[01] REMOVED AND REPLACED NEW EXIT SING AT LAVATORY B IN REF AMM 33-51-01-960-801-NG;[02] VERIFIEDSDR SWAA2023070551974Panel · delaminatedPANEL#521WB DELAMINATE EDGE AT I/B FWD CORNER.<[01] REMOVED ; ACCOMPLISHED REPAIR AND REINSTALLED PANEL #521WB AT LEFT WING PER AMM 57-41-02-400-801 ; AMM 57-41-02-000-801 AND SRM 51-70-04-2R-6 PARA 4.DSDR SWAA2023070551386Door · out of adjustACCOMPLISH L1 DOOR ADJUSTMENT<[01] ACCOMPLISHED L1 DOOR ADJUSTMENT UP TO STEP 2. U. (2) AS PER AMM 52-11-00-820-801-NG-01 LINER WILL BE INSTALLED ON TTG8Q00L7BU0;[02] VERIFIED DOOR ADJUSTED AND LINER INSTALLED ON TTG8Q00L7BU0SDR SWAA2023070563486Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL#241AF FOUND WITH DELAMINATION.<[01] APPLIED THE GLASS FABRIC REPAIR PLIES AT DAMAGED AREA ON PASSENGER CABIN FLOOR PANEL#241AF. REF B737 SRM 53-00-50-2R-1 REPAIR 1 PARAGRAPHG 3. MATERIAL USED GLASS FABRIC REPAIR PLIES PO#: 1738579 ASDR SWAA2023070563462Bracket · crackedL/W L/E UNDER PANEL #521NB NUT PLATE SUPPORT BRACKET CRACKED.<[01] REMOVED DAMAGE NUT PLATE CHANEL INSTALLED NEW NUT PLATE CHANNEL ON L/W L/E UNDER PANEL # 521NB SUPPORT BRACKET PER SRM 51-40-02 0G-0;[02] VERIFIED STEP 1; NUT PLATE CHANNEL REPLACED.SDR SWAA2023070550954Door · out of adjustL1 DOOR SAGGING; NO GAP WHEN DOOR CLOSED AT UPPER AFT END.<[01] ADJUSTMENTS WILL BE ACCOMPLISHED ON WORK CARD #TTG8Q00L7B4U;[02] VERIFIED FAULT WILL BE ACCOMPLISHED ON T/C TTG8Q00L7B4U.SDR SWAA2023070550629Floor Panel · deterioratedAFT CARGO COMPT. FLOOR PANEL 140DF DETERIORATED.<[01] AFT CARGO FLOOR PANEL #140DF WAS FABRICATED NEW ON JOB CARD TTG8QOO1RJXW.;[02] CORRECTION TO STEP 1: AFT CARGO PANEL #140DF WAS FABRICATED NEW ON JOB CARD TTG8Q001RJXW.;[03] VERIFIED STEP 2 PANEL FABRICATEDSDR SWAA2023070550627Floor Panel · deterioratedAFT CARGO COMPT. FLOOR PANEL 140AF DETERIORATED.<[01] AFT CARGO PANEL #140AF WAS FABRICATED NEW ON JOB CARD TTG8QOO1RJXW.;[02] CORRECTION TO STEP 1: AFT CARGO PANEL #140AF WAS FABRICATED NEW ON JOB CARD TTG8Q001RJXW.;[03] VERIFIED PANEL FABRICATED ON TTG8Q001RSDR SWAA2023070550630Floor Panel · deterioratedAFT CARGO COMPT. FLOOR PANEL 140BF DETERIORATED.<[01] AFT CARGO PANEL #140BF WAS FABRICATED NEW ON JOB CARD TTG8QOO1RJXW.;[02] CORRECTION TO STEP 1: AFT CARGO PANEL #140BF WAS FABRICATED NEW ON JOB CARD TTG8Q001RJXW.;[03] VERIFIED STEP 2 PANEL FABRICATED ON TTSDR SWAA2023070550633Floor Panel · deterioratedFWD CARGO COMPT. FLOOR PANEL 120AF DETERIORATED.<[01] FWD CARGO PANEL #120AF WAS FABRICATED NEW ON JOB CARD TTG8QOO1RJXW.;[02] CORRECTION TO STEP 1: FWD CARGO PANEL #120AF WAS FABRICATED NEW ON JOB CARD TTG8Q001RJXW.;[03] VERIFIED STEP 2 PANEL FABRICATED ON TTSDR SWAA2023070550634Floor Panel · deterioratedFWD CARGO COMPT. FLOOR PANEL 120CF DETERIORATED.<[01] FWD CARGO PANEL #120CF WAS FABRICATED NEW ON JOB CARD TTG8QOO1RJXW.;[02] CORRECTION TO STEP 1: FWD CARGO PANEL #120CF WAS FABRICATED NEW ON JOB CARD TTG8Q001RJXW.;[03] VERIFIED STEP 2 PANEL FABRICATED ON TTSDR SWAA2023042429825Seal · crackedLH STABILIZER LOWER FWD SLIDER SEAL CRACKED<[01] R/R LH STABILIZER LOWER FWD SLIDER SEAL IAW AMM 53-31-31SDR SWAA2023042429833Seal · crackedL/H STABILIZER FWD UPPER SLIDER SEAL CRACKED<[01] R/R LH STABILIZER FWD UPPER SLIDER SEAL IAW AMM 53-31-31SDR SWAA2022103165958Cover · brokenFWD ENTRY DOOR EMERGENCY LIGHT COVER BROKEN / [01] R&R FWD ENTRY DOOR EMERGENCY LIGHT COVER IAW AMM 33-51-01.SDR SWAA2021061678827Skin · crackedCRACK EXTERNAL GROUND ELECTRICAL POWER ACCESS DOOR CUT OUT LOWER AT LOWER FUSELAGE ; 2021-215742 / REPAIRED EXTERNAL GROUND ELECTRICAL POWER ACCESS DOOR CUT OUT LOWER AT LOWER FUSELAGE IAW SRM B737-700 53-10-15-2R-4 FIGURE 204 SHEET 1;REPAIRED EXTERNAL GROUND SDR SWAA2021061675349Support Angle · crackedCRACK SUPPORT ANGLE FRONT SPAR WEB BOOST PUMP AREA AT LT WING (1 EA) ; 2021-215674 / REPLACED SUPPORT ANGLE FRONT SPAR WEB BOOST PUMP AREA AT LT WING (1 EA) IAW B737-700 SRM 51-10-02-0G-0 AND DRAWING N 116A3001 SHEET 11 REV. -; REPLACED SUPPORT ANGLE FRONT SPASDR SWAA2021061682367Skin · dentedDENT EXTERNAL SKIN LOC AT BS 294.5 MORE 2 INCHES AND 3 INCHES BELOW STR 23L AT LOWER FUSELAGE ; 2021-215661 / REPAIRED EXTERNAL SKIN LOC. BTW BS 285.6 TO BS 312 AND BTW STR 23L TO 26L I.A.W EA #21-153-01520; PART 21-153-01520-WIP1 <BR>; PART 21-153-01520-WIP2 SDR SWAA2021061682366Skin · dentedDENT EXTERNAL SKIN LOC BTW BS 285.5 TO BS 303 AND BELOW STR 24L AT LOWER FUSELAGE ; 2021-215660 / REPAIRED EXTERNAL SKIN LOC. BTW BS 285.6 AND BS 312 AND BTW STR 22L TO STR 26L I.A.W EA #21-153-01520; PART 21-153-01520-WIP1; PART 21-153-01520-WIP2 REV B.;REPAISDR SWAA2021061682365Skin · dentedDENT EXTERNAL SKIN LOC BTW BS 235.8 TO BS 243.7 AND 4 INCHES BELOW STR 24R AT LOWER FUSELAGE ; 2021-215654 / FAULT RESOLVED ON OTHER FAULT #TTG8Q0052336;P/N: NORTEC 600D; S/N: 210138003; DUE DATE: 05-MAR-22;TOOL USED P/N NORTEC500D S/N N500X11290U021704 DUE DASDR SWAA2021061673333Angle · crackedCRACK ON ANGLE LOCATED ON BS 294.5 AT LEVEL OF STRINGER 13L AT FWD GALLEY AREA ; 2021-215628 / REPLACED ANGLE LOCATED ON BS 294.5 AT LEVEL OF STRINGER 13L AT FWD GALLEY AREA I.A.W B737-700 SRM 51-10-02 AND DWG# 141A1311 SHEET 1; REV C.;REPLACED ANGLE LOCATED OSDR SWAA2021061673332Angle · crackedCRACK ON ANGLE LOCATED BETWEEN BS 291.5 TO BS 294.5 AT LEVEL STRINGER 17 R AT FWD GALLEY AREA ; 2021-215627 / REPLACED ANGLE LOCATED BETWEEN BS 291.5 TO BS 294.5 AT LEVEL STRINGER 17 R AT FWD GALLEY AREA IAW B737-700 SRM 53-10-15-2R-7 REPAIR 7 AND IS DOCUMENTESDR SWAA2021061673331Stringer Clip · crackedCRACK TIE CLIP LOCATED ON BS277 AT LEVEL STRINGER 10R AT FWD GALLEY AREA ; 2021-215625 / REPLACED TIE CLIP LOCATED ON BS 277 AT LEVEL STR 10R AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG #141A1110 ;SHEET 18; REV -; REPLACED TIE CLISDR SWAA2021061673330Frame · crackedCRACK FRAME ON BS 312 BETWEEN STRINGER 5L TO STRINGER 6L AT FWD GALLEY AREA ; 2021-215624 / REPAIRED FRAME LOC ON BS 312 BETWEEN STRINGER 5L TO STRINGER 6L AT FWD GALLEY AREA IAW B737-700 SRM 53-1007-2R-1 REPAIR 1. THIS REPAIR IS CATEGORY B AND MUST BE RE-INSPSDR SWAA2021061673328Stub Frame · crackedCRACK STUD FRAME LOCATED ON BS 294.5 AT LEVEL STRINGER 17 R AT FWD GALLEY AREA ; 2021-215626 / REPAIRED STUD FRAME LOCATED ON BS 294.5 AT LEVEL STRINGER 17R AT FWD GALLEY AREA; IAW B737-700 SRM 53-10-15-2R-7.;TOOL USED: DIGITAL CALIPER P/N: 500-464; S/N: 15331SDR SWAA2021061673327Stub Frame · crackedCRACK INDICATION ON FORWARD GALLEY DOOR UPPER FORWARD CUTOUT CORNER STUB FRAME FASTENER HOLE. LOCATED AT BS 291.5 PLUS 6.75 INCH. AND 3 INCH. ABOVE STR9R AT UPPER FUSELAGE. ; 2021-215622 / REPLACED STUB FRAME AND FASTENERS LOCATED ON BS 294.5 BETWEEN STR 7R TOSDR SWAA2021061773315Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 312 TO STA 328 AND LBL 48 AT FWD GALLEY AREA ; 2021-215609 / REPLACED WEB INTERCOSTAL AND FASTENER LOCATED BETWEEN STA 312 TO STA 328 AND LBL 48 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9 SRMSDR SWAA2021061773314Support Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED BETWEEN STA 294.5 TO STA 328 RBL 59 AND WL 208.1 AT FWD GALLEY AREA ; 2021-215608 / REPLACED ANGLE - SUPPORT AND FASTENER LOCATED BETWEEN STA 294.5 TO STA 328 RBL 59 AND WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITSDR SWAA2021061773177Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 277 TO STA 294.5 AT LEVEL BL0 AT FWD GALLEY AREA ; 2021-215598 / TOOL USED RADIUS GAUGE P/N 5167C S/N AE-28532 DUE DATE 19-AUG-21; REPLACED WEB INTERCOSTAL AND FASTENER LOCATED BETWEEN STA 277 TO STA SDR SWAA2021061773828Floorbeam · corrodedCORROSION ON FLOOR BEAM STA 986 LBL 43 AND WL 208.1 AT AFT GALLEY AREA ; 2021-215619 / EA M-21-153-00612 COMPLETED.; EA M-21-153-00612 COMPLETED.; EA M-21-153-00612 COMPLETED.SDR SWAA2021061682364Skin · dentedDENT EXTERNAL SKIN LOC BTW BS 224.8 TO BS 235.8 AND 4 INCHES BELOW STR 24R AT LOWER FUSELAGE ; 2021-215620 / REPAIRED EXTERNAL FUSELAGE SKIN LOCATED BETWEEN BS 219.8 AND BS 235.8 + 6 AND 14 ABOVE OF STR 24R AND 10 BELOW OF STR 24R IAW EA # 21-153-01532-WIP1 ANSDR SWAA2021061673322Floor Support · corrodedCORROSION FLOOR STRUCTURE INNER CHORD LOCATED BETWEEN STA 312 STA 344 RBL 58 AND WL 208.1 AT FWD GALLEY AREA ; 2021-215607 / REPLACED INNER CHORD LOCATED BETWEEN STA 259.5 TO STA 360 RBL 58 AND WL 208.1 AT FWD GALLEY AREA IAW SRM B737-700 51-10-02 AND DWG 141ASDR SWAA2021061673319Angle · crackedCRACK ANGLE LOCATED ON BS 947.5 AT STR26L AT AFT CARGO COMPARTMENT ; 2021-215618 / REPLACED ANGLE LOCATED ON BS 947.5 AT STR26L AT AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-40-02 AND DWG 149A8103 REV: D.; REPLACED ANGLE LOCATED ON BS 947.5 AT STR26L AT AFT CSDR SWAA2021061673318Floor Support · corrodedCORROSION FLOOR STRUCTURE INNER CHORD LOCATED BETWEEN STA 951 TO STA 992.8 RBL 47 AND WL 208.1 AFT GALLEY AND LAV ; 2021-215616 / REPLACED INNER CHORD LOCATED BETWEEN STA 887 TO STA 1006 RBL 47 AND WL 208.1 AFT GALLEY AND LAV SRM B737-700 51-10-02 AND DWG 147ASDR SWAA2021061673317Floor Support · corrodedCORROSION FLOOR STRUCTURE INNER CHORD LOCATED BETWEEN STA 951 TO STA 992.8 LBL 47 AND WL 208.1 AFT GALLEY AND LAV ; 2021-215615 / REPLACED INNER CHORD LOCATED BETWEEN STA 887 TO STA 1006 LBL 47 AND WL 208.1 AFT GALLEY AND LAV IAW SRM B737-700 51-10-02 AND DWG SDR SWAA2021061673178Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 294.5 TO STA 312 AT LEVEL RBL 15 AT FWD GALLEY AREA ; 2021-215599 / REPLACED WEB INTERCOSTAL AND FASTENERS LOCATED BETWEEN STA 294.5 TO STA 312 AT LEVEL RBL 15 AT FWD GALLEY AREA I.A.W B737-700 SRM 51SDR SWAA2021061673176Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 312 TO STA 328 AT LEVEL RBL 31 AT FWD GALLEY AREA ; 2021-215606 / REPLACED WEB INTERCOSTAL AND FASTENER LOCATED BETWEEN STA 312 TO STA 328 AT LEVEL RBL 31 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 SDR SWAA2021061673175Floorbeam · corrodedCORROSION FLOOR BEAM ON STA 328; RBL 31 AND WL 208.1 AT FWD GALLEY AREA ; 2021-215601 / PERFORMED PERMANENT REPAIR ON FLOOR BEAM 328; RBL 31 AND WL 208.1AT FWD GALLEY AREA IAW B737-700 SRM 53-10-51-2R-7 REPAIR 7;PERFORMED PERMANENT REPAIR ON FLOOR BEAM 328; RBSDR SWAA2021061673174Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN STA 344 TO STA 360 AT LEVEL OF BL 0 FWD GALLEY AND LAV ; 2021-215597 / REPLACED WEB INTERCOSTAL AND FASTENER LOCATED BETWEEN STA 344 TO STA 360 AT LEVEL OF BL 0 FWD GALLEY AND LAV IAW B737-700 SRM 51-40-0SDR SWAA2021061772265Angle · crackedCRACK CLOSURE ANGLE ON BS 1021.27 BTW STR2L TO STR2R AT UPPER FUSELAGE (1 EA) ; 2021-215445 / REPLACED CLOSURE ANGLE (SPRING) AND FASTENERS ON BS 1021.27 BTW STR2L TO STR2R AT UPPER FUSELAGE (1 EA) I.A.W B737-700 SRM 51-40-02 AND DWG 175A3101 REV - .; REPLACEDSDR SWAA2021061772260Rib · crackedCRACK INSPAR RIB 120.30 AT 38IN FRONT SPAR AT RT HORIZONTAL STABILIZER ; 2021-215414 / INSPECTED OK HAND LAYOUT ON REPAIR AREA OF INSPAR RIB 120.30 IAW B737-700 SRM 55-10-09-2R-4 FIGURE 202SHEET 1 TOOL USED DIGITAL CALIPER P/N 700-113-10 S/N 0019298 DUE DATE 0SDR SWAA2021061771392Bear Strap · crackedCRACK INDICATION FOUND AROUND FASTENER LOCATED BEAR STRAP AT LEVEL FITTING-LATCH; STA 294.5 BETWEEN S-8R AND S-9R ; 2021-215390 / DIGITAL CALIPER P/N: 500-197-30;S/N: B20189527; DUE DATE: 23-NOV-21.;REMOVED RAIN GUTTER (2E/A) AND FASTENERS LOCATED BTW BS 291.5SDR SWAA2021061771032Angle · crackedCRACK ANGLE LOCATED BETWEEN BS663 TO BS706 AND RBL0 AT PASSENGER CABIN ; 2021-215358 / REPLACED ANGLE LOCATED BETWEEN BS 663 TO BS 706 AND RBL 0 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG # 273A9110 SHEET 6 REV. A; REPLACED ANGLESDR SWAA2021061771031Angle · crackedCRACK ANGLE LOCATED BETWEEN BS663 TO BS706 AND LBL0 AT PASSENGER CABIN ; 2021-215357 / REPLACED ANGLE LOCATED BETWEEN BS 663 TO BS 706 AND LBL 0 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG # 273A9111 SHEET 10 REV. -; REPLACED ANGLSDR SWAA2021061771030Support Angle · crackedCRACK REAR SPAR SUPPORT ANGLE LOCATED WS 253 TO WS 278 AT RT WING ; 2021-215349 / REPLACED SUPPORT ANGLE LOCATED REAR SPAR WS 253 TO WS 278 AT RT WING IAW B737-700 SRM 51-10-02; REPLACED SUPPORT ANGLE LOCATED REAR SPAR WS 253 TO WS 278 AT RT WING IAW B737-700 SDR SWAA2021061771029Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED BETWEEN WS 253 TO WS 278 RT WING ; 2021-215350 / INSTALLED SUPPORT ANGLE AND FASTENERS ON RT WING TRAILING EDGE AREA BTW WS 253 TO WSTA 273 IAW B737-700 SRM 51-40-02 AND DRAWING 115A6200 SHEET 10 REV; REPLACED SUPPORT ANGLE ANSDR SWAA2021061778060Spar · corrodedCORROSION FRONT SPAR WEB LOCATED FUEL BOOST PUMP IFSS 120 APPROX AND WBL 94.24 AT LT WING.SDR SWAA2021061770364Spar · corrodedCORROSION FRONT SPAR WEB LOCATED FUEL BOOSTER PUMP IFSS 120 APROX AND WBL 94.24 AT RT WING ; 2021-215293 / EVALUATED REWORKED AREA ON FRONT SPAR WEB LOCATED FUEL BOOSTER PUMP IFSS 120 APROX AND WBL 94.24 AT RT WING IAW B737-700 SRM SRM 57-20-10-1A-3;OK TO APPLSDR SWAA2021061470367Spar · corrodedCORROSION FRONT SPAR WEB LOCATED FUEL BOOST PUMP IFSS 120 APPROX AND WBL 94.24 AT LT WING ; 2021-215294 / SUMMARY EA 21-157-01494 HAS BEEN APPROVED; ACTIVATED; AND ATTACHED AS A SUBTASK TO FAULT TTG8Q004ZJE0.; REPAIRED FRONT SPAR WEB LOCATED FUEL BOOST PUMP IFSDR SWAA2021051069214Slide · low pressureAFT SERVICE DOOR SLIDE LOW PRESSURE ; / R&R AFT SERVICE DOOR SLIDE PER MT#725-61-06
Back to N440LV