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 SWAA2022030847303Beam · crackedDURING COMPLETION OF CCN: 14079 FOUND FORWARD SERVICE DOOR #4 (LOWER) BEAM TO BE CRACKED IN THE RADIUS ON THE INBOARD SIDE COMMON TO THE FORWARD MOST ATTACH POINT FOR THE DOOR HANDLE BOX ASSEMBLY. / FOWARD SERVICE DOOR #4 BEAM REMOVED AND REPLACED ON ATS COMPOSDR SWAA2022030847307None · crackedCRACKED FLOOR SUPPORT AT B.S. 540; B.L. 0 - L.B.L. 24.5; W.L.208.1. / REMOVED AND REPLACED PANEL BREAK AT BS 540 BL 0- LBL 24.5 PER SRM 51-40-02 AND DWG 143A0060 REV A. 59641U 28MAY19SDR SWAA2022030847308None · crackedCRACKED FLOOR SUPPORT AT B.S. 540; B.L. 0 - R.B.L. 24.5; W.L.208.1. / REMOVED AND REPLACED PANEL BREAK AT BS 540 BL0-RBL 24.5 PER SRM 51-40-02 AND DWG 143A0060 REV A. 59641U 28MAY19SDR SWAA2019061133475Bulkhead Web · crackedVERTICAL PRESSURE WEB CRACKED AT BS. 663, RBL 41. / REPAIRED WEB IAW SRM.SDR SWAA2019060733425Seat Track · damagedSEAT TRACK TOP MECHANICALLY TOP DAMAGED AT BS. 520, LBL 25. / R&R SEAT TRACK PER SRM AND DWG.SDR SWAA2019060633388Seat Track · damagedTOP OF SEAT TRACK MECHANICAL DAMAGED BETWEEN BS. 480 TO BS. 520, LBL 45. / R&R SEAT TRACK IAW SRM AND DWG.SDR SWAA2019060533338Pressure Deck · crackedHORIZONTAL PRESSURE DECK CRACKED BETWEEN BS. 663 TO 675, BETWEEN RBL 38 TO RBL 60. / REPAIRED DECK PER SRM.SDR SWAA2018122827931Battery · failedEMERGENCY LIGHT BATTERY M1674 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827930Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827929Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827928Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827927Battery · failedEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827926Battery · failedEMERGENCY LIGHT BATTERY M1668 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827819Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018121227601Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R&R COVER IAW SIP.SDR SWAA2022021647209Panel · crackedDAMAGE/CRACK FOUND ON PANEL 194 BL / R&R PANEL 194BL IAW AMM 53-51-21SDR SWAA2022021647210Panel · crackedDAMAGE/CRACK FOUND ON PANEL 194BR. / REMOVED AND REPLACED PANEL REF AMM 53-51-21.SDR SWAA2022021647211Plate · crackedRIGHT HAND INBOARD FLAP COVER PLATE FOUND DAMAGE AND CRACKED. / REMOVED AND REPLACED PER SIP.SDR SWAA2022021047076Panel · delaminatedBELLY PANEL 193B HAS A HOLE WITH DELAM FWD OF ATTACH HOLE #37. DAMAGE 1/2' IN DIAMETER AND 3 1/2' FWD OF T/E F PANEL MOD / ACCOMPLISHED PERMANENT REPAIR OF PUNCTURE AT 3 1/2' FORWARD OF TRAILING EDGE OF PANEL 193B IAW SRM 51-70-05-2R-2. 59644U 5/24/19SDR SWAA2018032920836Girt Bar · dirtyR2 DOOR SLIDE GIRT BAR FLOOR MOUNTED ANGLE DIRTY. CLEANED IAW MM.SDR SWAA2022012547191Strip · corrodedAFT CARGO R/H CAPSTRIP #2 FROM THE FRONT PN 453A2611-11 IS CORRODED OUT OF LIMITS. / MANUFACTURED AND DRILLED UP NEW CAPSTRIP IAW BOEING DWG. 453A2611 AND SRM 51-40-05; TREATED IAW SRM 51-20-01; PRIMED IAW SOPM 20-41-02; AND PAINTED IAW AMM 51-21-00.INSTALLED SDR SWAA2022012547192Strip · corrodedAFT CARGO R/H TRANSITION CAPSTRIP FROM STA. 847 TO 947 IS CORRODED OUT OF LIMITS / REMOVED AND REPLACED CAPSTRIP PER AMM 25-52-10SDR SWAA2022012547180Strip · corrodedAFT CARGO LEFT HAND CAP STRIP #3 FROM FRONT PN 453A2611-10 CORRODED OUT OF LIMITS / REMOVED AND REPLACED CAPSTRIP PER AMM 25-52-10SDR SWAA2022012547181Strip · corrodedAFT CARGO LEFT HAND CAP STRIP #1 FROM FRONT PN 453A2611-17 CORRODED OUT OF LIMITS / MANUFACTURED PER BOEING DWG. 453A2611; DRILLED UP NEW CAPSTRIP IAW SRM 51-40-02. TREATED IAW SRM 51-20-01; PRIMED IAW SOPM 20-41-02; AND PAINTED IAW AMM 51-21-00.INSTALLED PER SDR SWAA2022012547182Strip · corrodedAFT CARGO LEFT HAND CAP STRIP #2 FROM FRONT PN 453A2611-18 CORRODED OUT OF LIMITS / MANUFACTURED AND DRILLED UP NEW CAPSTRIP IAW BOEING DWG. 453A2611 AND SRM 51-40-05; TREATED IAW SRM 51-20-01; PRIMED IAW SOPM 20-41-02; AND PAINTED IAW AMM 51-21-00.INSTALLED CSDR SWAA2022012547174Bracket · crackedLH WING AFT SPAR UPPER SHELF PANEL LOWER SUPPORT CRACKED (APPROX..OUT REAR SPAR STATION 274) / REMOVED AND REPLACED BRACKET AND SEAL PER SRM 51-40-02SDR SWAA2022012547173Retainer · crackedLH WING AFT SPAR UPPER SHELF PANEL HAS BULB SEAL RETAINER CRACKED (APPROX..OUT REAR SPAR STATION 274) / REMOVED AND REPLACED BRACKET AND SEAL PER SRM 51-40-02SDR SWAA2017060714209Splice Strap · corrodedAFT CARGO SPLICE STRAP CORRODED AT BS 767+5, UNDER NUT PLATES BOTTOM SIDE. R&R STRAP PER SRM.SDR SWAA2022012647113Plate · crackedWAFFLE PLATE IS CRACKED ON LH WING TRAILING EDGE ABOVE #3 FLAP TRACK / REMOVED AND REPLACED WAFFLE PLATE IAW SRM 51-40-02 AND EA 1-757-13901.SDR SWAA2016101108623Lamp · inoperativeRIGHT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2016101108601Baffle · crackedBAFFLE ASSEMBLY CRACKED AT BS 408, RBL 25. REPAIRED THE BAFFLE IAW DWG.SDR SWAA2016101108622Baffle · crackedBAFFLE ASSEMBLY CRACKED AT BS 500B, LBL 25. REPAIRED THE BAFFLE IAW SRM.SDR SWAA2016100708525Stringer · crackedSTRINGER CRACKED AT BS 375, STRINGER 28L. REPAIRED THE STRINGER IAW SRM.SDR SWAA2016100508457Floor Support · corrodedFLOOR SUPPORT CORRODED BETWEEN BS 197 TO 204, BETWEEN RBL 5 TO RBL. R & R THE FLOOR SUPPORT IAW DWG.SDR SWAA2016100608494Stringer · crackedSTRINGER 25L CRACKED AT BS 500+12. R & R STRINGER IAW DWG.SDR SWAA2016090655445Stringer · crackedSTRINGER CRACKED AT BS 500A+12, STR 25L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655444Stringer · crackedSTRINGER CRACKED AT BS 500A+17, STR 24L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655443Stringer · crackedSTRINGER CRACKED AT BS 500A+11, STR 23L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655442Stringer · crackedSTRINGER CRACKED AT BS 500A+7, STR 22L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655441Stringer · crackedSTRINGER CRACKED AT BS 500A+7, STR 21L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655440Stringer · crackedSTRINGER CRACKED AT BS 500A+7, STR 20L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655439Stringer · crackedSTRINGER CRACKED AT BS 500A+13, STR 19L. REPAIRED STRINGER IAW EA.SDR SWAA2016090655438Stringer · crackedSTRINGER CRACKED AT BS 500A+6, STR 18L. REPAIRED STRINGER IAW EA.SDR SWAA2016063053367Battery · failedEMERGENCY LIGHTS BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R & R BATTERY IAW AMM.SDR SWAA2016063053366Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MAINTENANCE AND AMM.SDR SWAA2015120446714Light · inoperativeRIGHT OVERWING EMER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015110545776Light · inoperativeRIGHT OVERWING EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015070641282Light · inoperativeL2 DOOR EXTERIOR EMER EXTERIOR LIGHT LAMP INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2015062241055Post · crackedRIGHT NR 3 COCKPIT WINDOW POST, 2ND FASTENER HOLE UP FROM BOTTOM CRACKED. REPAIRED POST IAW EA.SDR SWAA2015062241054Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STAB STATION 129.50, 26" FROM FRONT SPAR. REPAIRED RIB IAW EO & EA.
Back to N440LV