N201LV
Service difficulty reports · 350
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 = 'N201LV' 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 = 'N201LV' 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 SWAA2016110109181Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016110109180Frame · crackedFRAME CRACKED AT BS 400 BETWEEN STRINGERS 8 - 9L. REPAIRED THE FRAME IAW EA.SDR SWAA2016110109179Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016110109178Frame · crackedFRAME CRACKED AT BS 380, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016110109174Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016110109173Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STRINGERS 8 - 9L. REPAIRED THE FRAME IAW EA.SDR SWAA2016102709131Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2016102709130Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2016102609090Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2016102609089Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2016112910019Support Fitting · corrodedL1 DOOR FORWARD GIRT BAR SUPPORT FITTING CORRODED. R&R FITTING IAW DWG.SDR SWAA2016111409599Floorbeam · corrodedAFT PASSENGER CABIN T CAP CORRODED AT BS 986, LBL 50. REPAIRED T CAP IAW SRM & EA.SDR SWAA2016110709439Strap · corrodedFLOOR STRUCTURE STRAP CORRODED AT BS 1029, LBL 3. R&R STRAP IAW DWG AND SRM.SDR SWAA2016110709438Crease Beam · corrodedR2 CREASE BEAM CORRODED. R&R CREASE BEAM IAW SRM AND DWG.SDR SWAA2016110709407Web · corrodedFLOOR WEB CORRODED AT BS 986.5, RBL 43. R & R THE WEB IAW SRM AND DWG.SDR SWAA2016110709406Crease Beam · corrodedCREASE BEAM CORRODED BETWEEN BS 927 TO 986, LBL 53. R & R THE CREASE BEAM IAW DWG AND SRM.SDR SWAA2016110409364Strap · corrodedFLOOR STRUCTURE STRAP CORRODED AT BS 1026, RBL 18. R&R STRAP IAW SRM AND DWG.SDR SWAA2016110109176Floor Support · corrodedFLOOR SUPPORT CORRODED AT BS 952, LBL 45. R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2016110109175Crease Beam · corrodedR1 DOOR THRESHOLD CREASE BEAM CORRODED. R & R THE CREASE BEAM IAW DWG & SRM.SDR SWAA2016110109172Support Fitting · corrodedFORWARD CABIN ENTRY DOOR AFT GIRT BAR SUPPORT FITTING CORRODED. R & R THE SUPPORT FITTING IAW DWG.SDR SWAA2016102609087Support Angle · corrodedFORWARD GALLEY DOOR THRESHOLD SUPPORT ANGLE CORRODED. R&R ANGLE IAW SRM AND DWG.SDR SWAA2016110809490Attach Angle · corrodedAFT CARGO BAY AFT BULKHEAD ATTACH ANGLE CORRODED AT BS 947, RBL 13. R & R THE ATTACH ANGLE IAW SRM AND DWG.SDR SWAA2016111009554Angle · corrodedAFT CARGO COMPARTMENT FLOOR ANGLE CORRODED BETWEEN BS 727 TO 847, LBL 22. R & R THE ANGLE IAW SRM.SDR SWAA2016110809489Support Angle · corrodedAFT CARGO BAY AFT LOWER BULKHEAD SUPPORT ANGLE CORRODED AT BS 947, BETWEEN RBL 20 TO 23. R & R THE SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2016110809404Floor Support · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED AT BS 903, RBL 8. REPAIRED THE FLOOR SUPPORT IAW SRM.SDR SWAA2016110709405Angle · corrodedFORWARD CARGO BAY RT ANGLE CORRODED AT BS 500+10. R & R THE ANGLE IAW SRM & DWG.SDR SWAA2016110709403Angle · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE ANGLE CORRODED BETWEEN BS 867 TO 887, RBL 21. R & R THE ANGLE IAW DWG & SRM.SDR SWAA2016110709402Angle · corrodedAFT CARGO COMPARTMENT RT SHIELD ANGLE CORRODED BETWEEN BS 767 TO 787, RBL 21. REPAIRED THE ANGLE IAW SRM AND DWG.SDR SWAA2016110709401Web · corrodedAFT CARGO DOOR CUTOUT LOWER THRESHOLD WEB CORRODED BETWEEN BS 794 TO 847, BETWEEN RBL 20 TO 26. R & R WEB IAW DWG AND SRM.SDR SWAA2016110109171Angle · corrodedFORWARD CARGO BAY LEFT ZEE ANGLE CORRODED BETWEEN BS 500 TO BS 500D. R & R THE ZEE ANGLE IAW SRM.SDR SWAA2016110109170Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED BETWEEN BS 927 TO 947, RBL 14. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2016110109165Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED BETWEEN BS 787 TO 847, RBL 14. R & R THE FLOOR SUPPORT IAW SRM & DWG.SDR SWAA2016102709129Angle · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE Z-ANGLE CORRODED BETWEEN BS 727 TO BS 767, RBL 22. R&R Z ANGLE IAW SRM.SDR SWAA2016102709128Floor Support · corrodedFLOOR SUPPORT TRACK CORRODED BETWEEN BS 907 TO BS 947, LBL 3. R&R FLOOR STRUCTURE PER SRM AND DWG.SDR SWAA2016090855590Battery Pack · inoperativeFORWARD EMERGENCY FLASHLIGHT INOPERATIVE. INSTALLED A NEW BATTERY PACK IAW SIP.SDR SWAA2016062453198Cover · missingEMERGENCY EXIT SIGN COVER MISSING. R & R COVER ASSEMBLY IAW AMM.SDR SWAA2016051051671Sign · damagedOVERHEAD OVERWING AISLE EXIT LIGHTED SIGN DAMAGED. R & R LAMP ASSEMBLY IAW MM.SDR SWAA2016032250106Lens · missingRIGHT OVERWING EMER EXIT SIGN LENS COVER MISSING. INSTALLED LENS IAW SIP.SDR SWAA2016011447987Battery · dischargedAFT OTBD EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW SIP MM.SDR SWAA2015110945860Lens · looseRIGHT EMER EXIT SIGN COVER LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015080342407Lens · unsecureL1 DOOR EMERGENCY LOWER LIGHT LENS COVER FELL OFF. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015032537752Slide · looseR1 DOOR EMER EVAC SLIDE LOOSE. R & R SLIDE IAW MT.SDR SWAA2015012235946Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED FROM HOLE SECOND FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2015011935831Pressure Deck · crackedVERTICAL PRESS DECK WEB CRACKED AT BS 663, BETWEEN LBL 31.83 TO LBL 40.00. REPAIRED WEB IAW SRM. .SDR SWAA2015012035891Skin · crackedRIGHT WING NR 7 SLAT SKIN AT NOSE ACTUATOR CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014092432248Skin · crackedRIGHT LOWER HORIZONTAL STABILIZER IN SPAR SKIN CRACKED APPROX 25 INCHES AFT OF FWD SPAR AT STAB STATION 184.70. REPAIRED SKIN IAW SRM.SDR SWAA2014091732058Electronic Unit · failedDECLARED EMER FLAPS WOULD NOT DEPLOY ON APPROACH. R & R FLAP SLAT ELEC UNIT IAW MM.SDR SWAA2014062729442Overheat Sensor · faultyMLG WW FIRE WARN SOUNDED DURING LG EXTENSION. R & R FAULTY OVERHEAT SENSOR .SDR SWAA2013011611476Door · looseRIGHT MAIN GEAR INNER DOOR LOOSE AT HINGE POINT. REMOVED AND REPLACED DOOR IAW AMM AND DRAWING.SDR SWAA2013011611475Skin · crackedNR 3 FLAP TRACK FAIRING INNER SKIN CRACKED. REPAIRED SKIN PER EA.
Back to N201LV