N340LV
Service difficulty reports · 436
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 = 'N340LV' 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 = 'N340LV' 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 SWAA2014120234580Support Bracket · crackedLEFT WING NR 3 AFT FLAP TRACK FAIRING SUPPORT BRACKET CRACKED BETWEEN WBL 183.40 TO 198.60. R & R BRACKET IAW SRM & DWG.SDR SWAA2014120234579Support Fitting · crackedLEFT WING NR 3 INBD FLAP TRACK FAIRING SUPPORT CLIP CRACKED. R & R CLIP IAW SRM & DWG.SDR SWAA2014120134516Tab · delaminatedRIGHT WING AILERON TAB FAIRING DELAMINATED. R & R TAB IAW AMM.SDR SWAA2014112634494Skin · corrodedRIGHT WING INBD AFT FLAP LOWER SURFACE CORRODED. REPAIRED FLAP IAW SRM.SDR SWAA2014112634508Angle · crackedANGLE CRACKED AT STATION 947.5 TO 967, STRINGER 26L TO 24L. R & R ANGLE IAW SRM.SDR SWAA2014112434399Fitting · crackedFUSELAGE CLIP CRACKED AT STATION 727, LBL 16. R & R CLIP IAW SRM.SDR SWAA2014111834253Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014111434180Attach Fitting · corrodedRIGHT WING NR 5 FLAP TRACK FWD ATTACH FITTING CORRODED AROUND HOLE. REPAIRED FITTING IAW CMM.SDR SWAA2014120434658Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 15L. REPAIRED FRAME IAW EA.SDR SWAA2014112134381Frame · crackedAFT CARGO COMPARTMENT FRAME CRACKED AT BS 947.5 STRINGER 18R. R & R FRAME IAW SRM & DWG.SDR SWAA2014111834252Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 18L. R & R FRAME IAW SRM & DWG.SDR SWAA2014111734193Plate · crackedACCESS PANEL 9507L PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014120434657Skin · delaminatedRIGHT WING NR 5 SLAT SKIN DELAMINATED. R & R NR 5 SLAT IAW MM.SDR SWAA2014120434655Frame · crackedFRAME CRACKED AT BS 296.4, STRINGER 7R. REPAIRED FRAME IAW EA.SDR SWAA2014120334605Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 967, STRINGER 8R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014120234578Slat · crackedLEFT WING NR 1 LE SLAT CRACKED AROUND FASTENER HOLES. REPAIRED NR 1 SLAT IAW SRM.SDR SWAA2014120134524Support Angle · crackedRIGHT WING SUPPORT ANGLE TE LOWER SURFACE CRACKED AT WBL 198.00. R & R ANGLE IAW SRM & DWG.SDR SWAA2014120134523Slat · crackedLEFT WING NR 3 SLAT CRACKED AROUND LOWER AREA. R & R NR 3 SLAT IAW SRM.SDR SWAA2014120134522Frame · crackedFRAME CRACKED AT BS 344, STRINGER 6L. REPAIRED FRAME IAW EO & EA.SDR SWAA2014111834251Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 360, STRINGER 9L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014111734192Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 TO 291, BETWEEN STRINGER 11R TO 10R. R & R ANGLE IAW SRM & DWG.SDR SWAA0111110134005Web · crackedWEB CRACKED BETWEEN BS 277 TO 291 STRINGER 14R. R & R WEB IAW SRM & DWG.SDR SWAA2014110733892Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO 328, RBL 31.6. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014120134515Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2 RBL 39. REPAIRED WEB IAW EA.SDR SWAA2014120134514Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2 RBL 38. REPAIRED WEB IAW EA.SDR SWAA2014112634507Angle · crackedMLG WW ANGLE CRACKED AT STATION 680, LBL 69. R & R ANGLE IAW SRM.SDR SWAA2014111234083Structure · crackedNOSE LANDING GEAR RT WW CRACKED AT BS 243.7 + 2.5, WL 169.1. REPAIRED WW IAW SRM.SDR SWAA2014120834771Skin · crackedSKIN CRACKED AT BS 727, STRINGER 18A RT SIDE, AFT LOWER HOLE. REPAIRED SKIN IAW EO & EA.SDR SWAA2014120834770Skin · crackedSKIN CRACKED AT BS 727, STRINGER 18A RT SIDE, FWD LOWER HOLE. REPAIRED SKIN IAW EO & EA.SDR SWAA2014120834769Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT SIDE, FWD UPPER HOLE. REPAIRED CHORD IAW EO & EA.SDR SWAA2014120834747Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT SIDE, CRACKED ON FWD LOWER HOLE. REPAIRED CHORD IAW EO & EA.SDR SWAA2014120534711Frame · crackedLEFT FRAME OTBD CHORD CRACKED AT BS 727, BETWEEN STRINGER 19L TO 20L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014120534710Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2014102733375Light · inoperativeFORWARD ENTRY EMER EXIT SIGN INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014102733374Charger · inoperativeFORWARD ENTRY EMER EXIT SIGN INOPERATIVE. R & R BATTERY CHARGER IAW MM.SDR SWAA2014092232150Web · crackedWEB STRAP CRACKED AT BS 328 FLOORBEAM CTR AREA. R & R WEB IAW SRM.SDR SWAA2014092232149Light · inoperativeL1 DOOR EMER EXIT SIGN LAMP INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2014092232148Lens · missingLEFT EMER EXIT LIGHT LENS COVER MISSING. INSTALLED LENS IAW MM.SDR SWAA2014072530310Battery Pack · dischargedFORWARD ENTRY FLOOR LEVEL EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014072530309Lens · crackedL1 DOOR EMER EXIT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2014072530302Battery Pack · dischargedAFT ENTRY FLOOR LEVEL EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014071529999Cover · looseL1 DOOR EMER EXIT SIGN COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2014061629060Battery Pack · dischargedAFT GALLEY EMER EEPLS INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014061629049Battery · dischargedL1 DOOR EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014061629047Battery · dischargedR1 DOOR EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014051227858Cover · missingROW 12 DEF OVERHEAD BIN EGRESS LIGHT COVER MISSING. INSTALLED COVER IAW MM.SDR SWAA2014042527370Window · arcedR1 COCKPIT WINDOW ARCING NEAR UPPER LT CORNER. R & R R1 WINDOW IAW MM.SDR SWAA2014040126703Charger · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R & R CHARGER IAW MM.SDR SWAA2014040126702Battery · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R & R BATTERY IAW MM.SDR SWAA2014040126701Light · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R & R LIGHT ASSEMBLY IAW MM.
Back to N340LV