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 SWAA2021030451906Light · inoperativeAFT ENTRY SLIDE LIGHT EMERGENCY INOP. / RELAMPED AFT ENTRY SLIDE EMERGENCY LIGHT REF AMM 33-51-04.SDR SWAA2020120132811Strap · brokenCREW REPORTS AFT INBOARD FLASHLIGHT STRAP BROKEN. R & R AFT INBOARD EMERGENCY FLASHLIGHT BOTTOM STRAP, PER MM 25-64-00.SDR SWAA2021081026657Fairing · damagedPANEL 193B HAS ELONGATED FASTENER HOLES. / REPLACED PANEL 193B PER EO 14108 AND SRM 51-40-02SDR SWAA2021072026656Counterbalance · corrodedRUDDER COUNTER BALANCE WEIGHT CORRODED / REMOVED AND REPLACED RUDDER COUNTER BALANCE WEIGHT PER CMM 55-40-09SDR SWAA2020081707669Floorboard · puncturedCABIN FLOORBOARD 242AF LOWER SURFACE HAS 2EA PUNCTURES. / REPAIRED 2EA; PUNCTURES ON LOWER SURFACE OF PANEL 242AF; IAW B737-700 SRM 53-00-50-2R-1; SRM 53-00-50-2R-0SDR SWAA2020081707657Floorboard · delaminatedCABIN FLOORBOARD 232SF HAS FWD INBD CORNER DELAMED. REPAIRED CABIN FLOORBOARD 232SF FWD INBD CORNER IAW B737 SRM 53-00-50-2R-4 AND B737 SRM 53-00-50-2R-0.SDR SWAA2020081707660Floorboard · damagedCABIN FLOORBOARD 242BF AFT INBD CORNER HAS DAMAGE. REPAIRED CABIN FLOOR BOARD 242BF I/B CORNER IAW B 737 SRM 53-00-50-2R-1 REV 71 AND B 737 SRM 53-00-50-2R-0 REV 71.SDR SWAA2020081707661Floorboard · damagedCABIN FLOORBOARD 241CF FWD OTBD EDGE HAS DAMAGE. REPAIRED AREA AT FWD O/B EDGE WITH 1 PLY & CORE DAMAGE ON PANEL 241CF IAW B737 SRM 53-00-50-2R-4; SRM 53-00-50-2R-0; AIPC 53-21-00-09.SDR SWAA2020081707662Floorboard · damagedCABIN FLOORBOARD 241BF FWD OTBD CORNER HAS EDGE DAMAGE. REPAIRED CABIN FLOOR BOARD 241BF FWD O/B CORNER EDGE DAMAGE IAW B 737 SRM 53-00-50-2R-1 REV 71 AND B 737 SRM 53-00-50-2R-0 REV 71SDR SWAA2020081707668Floorboard · damagedCABIN FLOORBOARD 241AF AFT CORNERS HAVE EDGE DAMAGE. / PANEL 241AF FOUND TO BE B.E.R. REPLACED BY FABRICATION. WORK ACCOMPLISHED ON W.O. # 41390/2400/0013 DEFECT # Y0236953SDR SWAA2020081707667Floorboard · damagedCABIN FLOORBOARD 241AF UPPER SURFACE HAS PULLED FIBERS. / FOUND FLOORBOARD 241AF TO BE B.E.R. REPLACED BOARD BY FABRICATION WITH EXISTING BOARD AS TEMPLATE. IAW B737-700 SRM 53-00-50-2R-0; BOEING DWG 144A5810-127; BAC5085SDR SWAA2020081707663Floorboard · damagedCABIN FLOORBOARD 231XF UPPER AND LOWER SURFACE HAS PULLED FIBERS. / REPAIRED FLOORBOARD 231XF BY FABRICATING NEW BOARD IAW BOEING DRAWING 144A5810 REV -; 737-700 SRM 53-00-50-2R-0 REV. 71 AND BAC 5085 REV. ESDR SWAA2020081707670Floorboard · damagedCABIN FLOORBOARD 242AF FWD EDGE HAS DAMAGE. REPAIRED CORE AT FWD EDGE OF PANEL 242AF. IAW B737-700 SRM 53-00-50-2R-10; SRM 53-00-50-2R-0.SDR SWAA2020081707666Floorboard · damagedCABIN FLOORBOARD 231ZF HAS EDGE DAMAGE IN MULTIPLE AREAS. / REPAIRED MULTIPLE AREAS OF EDGE DAMAGE ON FLOORBOARD 23ZF IAW 737-700 SRM 53-00-50-2R-10 REPAIR 10 REV. 71; SRM 53-00-50-2R-0 REPAIR GENERAL REV. 71SDR SWAA2020081707665Floorboard · damagedCABIN FLOORBOARD 231YF HAS EDGE DAMAGE IN MULTIPLE AREAS. / REPAIRED MULTIPLE AREAS OF EDGE DAMAGE ON FLOORBOARD 231YF IAW 737-700 SRM 53-00-50-2R-10 REPAIR 10 REV. 71; SRM 53-00-50-2R-0 REPAIR GENERAL REV. 71.SDR SWAA2020081707659Floorboard · puncturedCABIN FLOORBOARD 232SF UPPER SURFACE HAS PUNCTURES. / REPAIR 2 EA PUNCTURES IN CABIN FLOORBOARD 232SF UPPER SURFACE IAW B737 SRM 53-00-50-2R-1 PARA 3 AND B737 SRM 53-00-50-2R-0SDR SWAA2020081707656Floorboard · puncturedCABIN FLOORBOARD 232RF HAS PUNCTURES ON LOWER SURFACE. / REPAIRED LOWER SURFACE PUNCTURE ON CABIN FLOOR BOARD 232RF IAW SRM 53-00-50-2R-1 REV 71 AND SRM 53-00-50-2R-0 REV 71SDR SWAA2020081707397Angle · crackedRIGHT PACK BAY. LOWER CENTER TANK HORIZONTAL ANGLE AT STATION 663 IS CRACKED 2ND FASTENER OUTBOARD OF VERTICAL KEEL BEAM ANGLE. MARKED /SDR SWAA2020081207009Skin · delaminatedLEFT WING OUTBOARD AFT FLAP INBOARD END; SKIN SEPERATED AT AFT CORNER / REPAIRED AREA OF DELAMINATION OF .50'D X 1.0'L ON LEFT WING AFT I/B EDGE OF AFT FLAP O/B. IAW B737-700 SRM 57-53-01-2R-14; SRM 51-70-10-2R-1; SRM 51-70-10-2R-0SDR SWAA2020060389012Handle · looseASSIST HANDLES LOOSE AT L-1 DOOR AFT OF DOOR, ON R-1 DOOR AND ON G-1 GALLEY. TIGHTENED ASSIST HANDLES AT L-1 DOOR AFT OF DOOR ON R-1 DOOR AND ON G-1 GALLEY IAW AMM 25-21-31-420-802 STEP 3B(6), AMM 52-41-31-400-802 STEP 3F(2) AND CMM 25-31-03 STEP 2A.SDR SWAA2020060387946Handle · looseASSIST HANDLES LOOSE AT L-1 DOOR AFT OF DOOR, ON R-1 DOOR AND ON G-1 GALLEY. TIGHTENED ASSIST HANDLES AT L-1 DOOR AFT OF DOOR, ON R-1 DOOR AND ON G-1 GALLEY IAW AMM 25-21-31-420-802 STEP 3B(6), AMM 52-41-31-400-802 STEP 3F(2) AND CMM 25-31-03 STEP 2A.SDR SWAA2021081781042Bracket · corroded***CORROSION*** ON BRACKET FWD SIDE OF FRAME AT STA 986.5; BL 0; WL 165 / REMOVED DAMAGED BRACKET AT STA 986.5 BL 0; WL 165 & INSTALLED NEW BRACKET P/N 7535584; PO. 793983 IAW SRM 51-40-02-0G-0; DWG 147A1086SDR SWAA2020032330814Handle · cracked#1 FIRE PULL HANDLE CRACKED / REMOVED AND REPLACED THE #1 FIRE HANDLE COVER PER SIPSDR SWAA2021081307952Angle · crackedAFT OF LEFT ENGINE PYLON; UPPER T/E SHELF PANEL MID SEAL BRACKET; ANGLE CRACKED ON FWD SIDE. / REMOVED AND REPLACED PER SRM 51-40-02.SDR SWAA2019102213887Sign · brokenCENTER CABIN EMERGENCY EXIT SIGN BROKEN. / R&R SIGN PER AMM.SDR SWAA2019061133478Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS. 495, STR. 24L. / R&R STRINGER CLIP PER SRM AND DWG.SDR SWAA2022030947347Attach Bracket · crackedAFT CARGO BAY ATTACH BRACKET CRACKED BS 867 LBL 9 WL 155 / REMOVED AND REPLACED DAMAGED BRACKET AT BS 867 LBL 9 IAW SRM CH 51-40-05. SRM CH 51-40-02SDR SWAA2019060733412Shield · corrodedAFT CARGO BAY FORWARD SHIELD ATTACH ANGLE CORRODED BETWEEN BS. 767 T0 BS. 794, RBL 21. R&R SHIELD IAW SRM AND DWG.SDR SWAA2022030947336Scuff Plate · crackedFWD CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED / FWD CARGO BAY FWD CORNER SCUFF PLATE WAS REMOVED; REPAIRED & REINSTALLED IAW EA 1-A53-2076 REV IISDR SWAA2022030947337Scuff Plate · crackedFWD CARGO BAY AFT CORNER SCUFF PLATE IS CRACKED / FWD CARGO BAY AFT SCUFF PLATE WAS REMOVED; REPAIRED AND REINSTALLED IAW EA 1-A53-2076 REV IISDR SWAA2022030947338Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED / AFT CARGO BAY FWD CORNER SCUFF PLATE REPAIRED IAW EA 1-A53-2076 REV IISDR SWAA2022030947341Skin · dentedDENT & SCRATCH UNDER AFT PROVISIONING DOOR DISCOVERED DURING POST FLIGHT INSPECTION.(DAMAGE LOCATION STA 947 + 8'; 2' BELOW STR- 21R) REF:J10227974 / DENT AND SCRATCH AT BS 947+8'; 2' BELOW STR 21R FOUND TO BE OUT OF LIMITS PER SRM 53-00-01-1A-1 CUTOUT DAMAGE SDR SWAA2022030947327Cover · crackedR/H AILERON BALANCE TAB #1 I/B AND O/B HINGE COVERS CRACKED / R/H AILERON BALANCE TAB #1 I/B AND O/B HINGE COVERS RECEIVED. INSTALLATION WILL BE ACCOMPLISHED ON CUSTOMER CARD #T934239 AND AMM 27-11-21-400-801 STEP 3.E(4)(D) 56790U 6/3/19SDR SWAA2022030947328Cover · crackedR/H AILERON BALANCE TAB #4 I/B HINGE COVER CRACKED / R/H AILERON BALANCE TAB #4 I/B HINGE COVER RECEIVED. INSTALLATION WILL BE ACCOMPLISHED ON CUSTOMER CARD# T934239 AND AMM 27-11-21-400-801 STEP 3.E (4)(D) 56790U 06/03/19SDR SWAA2022031047320Web · corroded***CORROSION*** ON AFT CARGO BAY SUB WEB THRESHOLD AT B.S. 794-847; R.B.L. 26; W.L. 155. / REPLACEMENT OF AFT CARGO BAY SUBTHRESHOLD WEB BS 794 - 847 RBL 26 W/L 155 IS ACCOMPLISHED ON CUSTOMER CARD T954481SDR SWAA2022030947315Skin · corroded***CORROSION*** ON FUSELAGE SKIN; UNDER DORSAL FIN; AT B.S. 907-1007. / FUSELAGE SKIN UNDER DORSAL FIN B.S 907 - 1007 STR 2R - 2L REPAIRED IAW EA 1-753-35019 REV IR AND ATS ER 19-03498 REV IRSDR SWAA2019061133476Frame Splice · corrodedAFT CARGO BAY FRAME SPLICE CORRODED AT BS. 787, RBL 25. REPAIRED FRAME SPLICE PER ER AND EA.SDR SWAA2019060733432Support · corrodedAFT CARGO BAY AFT BULKHEAD CENTER PANEL LOWER SUPPORT CORRODED AT BS. 947, BETWEEN LBL 21 TO RBL 21. / R&R SUPPORT ER DWG & SRM.SDR SWAA2019060733431Floorbeam · corrodedAFT CARGO BAY FLOOR PANEL SUPPORT CORRODED AT BS. 887, BETWEEN LBL 21 TO RBL 21. R&R SUPPORT IAW SRM & DWG.SDR SWAA2019060733430Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 767 TO BS. 794, RBL 21. / R&R SHIELD PER SRM & DWG.SDR SWAA2019060733429Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 727D+10 TO BS. 767, RBL 21. R&R SUPPORT IAW SRM & DWG.SDR SWAA2019060733428Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 727 TO BS. 847, LBL 21. / R&R SUPPORT IAW SRM AND DWG.SDR SWAA2019060533340Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 847 TO BS. 867, RBL 21. / R&R SHIELD IAW DWG & SRM.SDR SWAA2019060733427Cargo Track · corrodedAFT CARGO BAY FLOOR TRACK CORRODED AT BS. 807, RBL 14. / R&R FLOOR TRACK IAW SRM & DWG.SDR SWAA2019060733426Support · corrodedFORWARD CARGO BAY ON L/H FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 400 TO BS. 500D, LBL 22. / R&R SUPPORT IAW SRM AND DWG.SDR SWAA2019060733411Angle · crackedFORWARD CARGO BAY INTERCOSTAL TO FRAME CLIP CRACKED AT BS. 500B, RBL 25. R&R CLIP IAW SRM AND DWG.SDR SWAA2019060533339Support · corrodedFORWARD CARGO BAY FLOOR TO SIDEWALL SHIELD CORRODED BETWEEN BS. 500A TO BS. 500D, RBL 24. / R&R SUPPORT IAW SRM & DWG.SDR SWAA2022030847290Seal · crackedLEFT HAND HORIZONTAL STABILIZER FORWARD UPPER SLIDE SEAL PLATE IS CRACKED. / REMOVED CRACKED LEFT HAND HORIZONTAL STABILIZER FWD UPPER SLIDE SEAL IAW AMM 53-31-31-000-801 AND INSTALLED NEW SLIDE SEAL IAW AMM 53-31-31-400-801SDR SWAA2022030847291Seal · crackedLEFT HAND HORIZONTAL STABILIZER FORWARD LOWER SLIDE SEAL PLATE IS CRACKED. / REMOVED L/H HORIZONTAL STAB FWD LOWER SLIDE SEAL IAW AMM 53-31-31-000-803 AND INSTALLED NEW FWD LOWER SLIDE SEAL IAW AMM 53-31-31-400-803SDR SWAA2022030847292Seal · crackedRIGHT HAND HORIZONTAL STABILIZER FORWARD UPPER SLIDE SEAL PLATE IS CRACKED. / REMOVED RH HORIZONTAL STAB FWD UPPER SLIDE SEAL IAW AMM 53-31-31-000-802 AND INSTALLED NEW FWD UPPER SLIDE SEAL IAW AMM 53-31-31-400-802
Back to N440LV